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
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.
