[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