Post reply

Very slow insert using ssis package

  • February 24, 2011 at 10:57 am

    #100354

    I count not figure out the issue that why Insert in one particular table is very slow. I use the same ssis package for other table and it did inserted 45 million rows in 10 Minutes but for one specific table it is inserting 1.5 million rows in one hour.

    Source and destination tables are on the same server. There is no trigger and no indexes on this table.

    Any idea ?

  • February 24, 2011 at 11:00 am

    #1291138

    Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1069131-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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