Home Forums SQL Server 2005 SQL Server 2005 Integration Services Batch Processing by reading data from a table to a ole db destination RE: Batch Processing by reading data from a table to a ole db destination

  • August 13, 2009 at 11:42 am

    #1038878

    Naveen,

    And all of this becasue you don't know how to do this in the data flow? How long does it take the data flow to run and populate the 30,000 rows into your temp table? Surely not more than a few seconds, right? I would be the vast majority of the time spent during that hour run is looping through the rows.

    Can you tell us how long the data flow portion of you package takes to load the temp tables?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden