SQL Server Performance

DTS Performance

Discussion in 'SQL Server DTS-Related Questions' started by Anahi, Nov 30, 2005.

  1. Anahi New Member

    Hi everybody!

    I'm a new member here.
    Here is my question:
    I'm using a DTS to transfer data from a .csv file to a table. The problem is that the transference takes a lot of time when the table has a lot of information. Someone knows if there is a way to optimize it?, I don't know if the indexes are used when the import is performed. In some place I read that the indexes were not so good using DTS, is it right?
    Thanks a lot,


    Anahi
  2. Luis Martin Moderator

    If you can, is better drop indexes and after import was done, recreate indexes.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page