Post reply

Package is slow while transfer records between two tables

  • January 27, 2014 at 5:12 am

    #396169

    Hi

    I am using sql server 2008 ssis package.

    I am transferring records (around 20 laks) from one table to another.

    It is very slow. taking around 30 mins to copy. (i do not have indexes on destination table)

    Please suggest me what are the area i will look into

    thanks in Advance

    Rohit

  • January 27, 2014 at 5:17 am

    #1683490

    Do you have index on Source table?

    Are you copying all data or you have some where clause while selecting from Source table?

    Are you running the package from a SQL Job or in the design mode?

  • January 27, 2014 at 5:21 am

    #1683492

    rohit.kumar.barik (1/27/2014)

    Hi

    I am using sql server 2008 ssis package.

    I am transferring records (around 20 laks) from one table to another.

    It is very slow. taking around 30 mins to copy. (i do not have indexes on destination table)

    Please suggest me what are the area i will look into

    thanks in Advance

    Rohit

    Make sure you are using the fast load option in the OLE DB Destination.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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