August 13, 2009 at 12:08 pm
I have an ssis package that has several data flow tasks to select from sqlserver 2005 tables and output to an Access mdb. The provider in the connection is Microsoft.Jet.OLEDB.4.0 . The package runs successfully but the speed is painfully slow. I used to run the same thing in dts in a fraction of the time. Is there a way to speed the ssis package up - some setting I should be looking for?
September 9, 2009 at 4:21 pm
elaine (8/13/2009)
I have an ssis package that has several data flow tasks to select from sqlserver 2005 tables and output to an Access mdb. The provider in the connection is Microsoft.Jet.OLEDB.4.0 . The package runs successfully but the speed is painfully slow. I used to run the same thing in dts in a fraction of the time. Is there a way to speed the ssis package up - some setting I should be looking for?
Check ODBC Destination. The speed increase is 5x and more. With the regular OLE DB the insert speed gets slower and slower the more data you insert.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply