Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: SQLServer to Teradata data load via DTS

    I am extracting data from an SQLServer database to load into Teradata using DTS. The performance is abysmal. The same data in a text file loads quickly via multiload. I can move the data to other DBMSs via DTS quickly as well. Is there some way for me to improve the elapsed time/performance while using DTS? If not, what is the best way to move data from SQLServer into Teradata?

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    BCP/BULK INSERT. Actually DTS utilizes BCP-ish technology, but by using straight BCP or BULK INSERT you avoid the DTS overhead.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts