Post reply

Tuning an DTS

  • February 6, 2011 at 1:52 am

    #149878

    We are exporting data (in millions) from DB2 to a SQL server 2000 through DTS. It takes about 5-6hrs for the DTS to complete. Is there any options/ways to fine tune this, so as to reduce the run time.

    Assume that the DTS is an simple source to destination without any additional tasks (ActiveX, Queries etc)

  • February 6, 2011 at 3:10 am

    #1282848

    Duplicate post. No replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1059209.aspx


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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