speeding up ssis package that writes to ms access

  • elaine-131617

    Ten Centuries

    Points: 1066

    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?

  • COZYROC

    One Orange Chip

    Points: 28499

    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.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply