[AccessD] using a saved SSIS with VB.Net

....I second that. For the first time (ever I think for me) it apears that I may actually have an 'on sale' of something I have already written. Hallelujah.....

Kath
  ----- Original Message ----- 
  From: William Hindman 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, April 24, 2007 1:23 PM
  Subject: Re: [AccessD] using a saved SSIS with VB.Net


  ...recurring income ...the holy grail of every independent :)

  William Hindman

  ----- Original Message ----- 
  From: "JWColby" <jwcolby at colbyconsulting.com>
  To: "'Access Developers discussion and problem solving'" 
  <accessd at databaseadvisors.com>
  Sent: Monday, April 23, 2007 9:29 PM
  Subject: Re: [AccessD] using a saved SSIS with VB.Net


  > >Have you thought about leaving town with no forwarding address instead??
  >
  > LOL, not at all. If I figure this out, it could turn into thousands of
  > dollars a month in recurring income.  We like recurring income!
  >
  >
  > John W. Colby
  > Colby Consulting
  > www.ColbyConsulting.com
  >
  > -----Original Message-----
  > From: accessd-bounces at databaseadvisors.com
  > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
  > Sent: Monday, April 23, 2007 8:01 PM
  > To: Access Developers discussion and problem solving
  > Subject: Re: [AccessD] using a saved SSIS with VB.Net
  >
  > Have you thought about leaving town with no forwarding address instead??
  > LOL
  >
  > Charlotte Foust
  >
  > -----Original Message-----
  > From: accessd-bounces at databaseadvisors.com
  > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
  > Sent: Monday, April 23, 2007 4:13 PM
  > To: 'Access Developers discussion and problem solving'
  > Subject: Re: [AccessD] using a saved SSIS with VB.Net
  >
  > Well, it took about three hours to build an Access VBA system to turn the
  > fixed width file into a CSV with the leading / trailing spaces stripped 
  > off
  > of every field.  The code runs about 2.5 K records / second for the
  > conversion portion.  I name the CSV file with a fixed name and linked the
  > file to Access, so once that is done I run a simple append query that 
  > pulls
  > the data back out of the CSV and appends it into the SQL Server table.
  >
  > Unfortunately the append to SQL process is running at a little better than
  > 500 records / second.  I have to figure that out or this will take weeks.
  >
  > I have ~ 100 million records to convert so...
  >
  > John W. Colby
  > Colby Consulting
  > www.ColbyConsulting.com
  >
  >
  > -- 
  > AccessD mailing list
  > AccessD at databaseadvisors.com
  > http://databaseadvisors.com/mailman/listinfo/accessd
  > Website: http://www.databaseadvisors.com
  > 



  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com