Hello There!

I have a text file containing 3,876,240 rows and i am
using a simple DTS package to copy this text file into a
table with same column definition.

According to the Status bar on the "Executing DTS Package"
window it loaded in less than 3 minutes 3,876,200 rows and
then it totally slows down and for the last 240 rows it's
taking over 40 minutes, something gotta be wrong in what i
am doing.

Gotta be a faster way to do this load, please any ideas
are highly appreciated!!

thanks!!

The time at the end is when it is updating all the indexes. How many
indexes do you have on the table and is the file in the order of the
clustered index?

--
Andrew J. Kelly SQL MVP


"martino" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Have you considered using BULK INSERT command?
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


"martino" <anonymous (AT) discussions (DOT) microsoft.com> wrote