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 10, 2009 at 5:20 pm

    #1037144

    Jack Corbett (8/10/2009)

    John Rowan (8/10/2009)

    You should be able to accomplish this by seting the Maximum Insert Commit Size setting on your OLE DB Destination Fast-Load component.

    Duh, why didn't I think of that?

    That's why we all work together here, right! I've been "duh'd" too many times:-).

    Anyway, that is assuming that the OLE DB Destination w/ fast-load is being used.

    John Rowan

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