[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
>