Post reply

Batch Commit in ''Execute SQL Task'' ??

  • May 27, 2005 at 10:18 am

    #362742

    Dear All

    I want to transfer 4 millions of data using the below code in 'Execute SQL Task'.

    insert into <Linkedserver>.<database>.<User>.<table1> select * from <table2>

    Will it be possible to commit every 10000 records on the above statement.

    I have already used 'batch size' option in 'Transform Data Task'. I want to implement this in 'Execute SQL Task'

    Any other alternatives for this?

    Thanks in Advance

    Agson C A

  • May 30, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • May 30, 2005 at 4:56 pm

    #561788

    In DTS, the Transform Data task is your best option in terms of speed and batch processing. In the ExecuteSQL task the statement is submitted as one batch.

    Another option you could look at is dumping the data to a text file via BCP, and loading it at the source using BULK INSERT.

     

    --------------------
    Colt 45 - the original point and click interface

  • May 31, 2005 at 1:28 am

    #561815

    Hi Phill Carter

    Thanks for your suggestion..I will try it out..

    Regards

    Agson Chellakudam

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

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