I have a DTS import that imports a text file into a sql server table. The
file is around 650MB and contains about 1.5 million rows. I tried importing
it 3 times and each time it would import around 790,000 records and say it
was complete!!! So I split the file into 3 separate files thinking there may
be a max # of records it could import. I put 700,000 records in the first
two files and the rest in the last file. When I tried to import my new
files, it imported 1/2 of each file!!!!!!!!!!!! I am about to go nuts
trying to figure this one out. Anyone have a suggestion?

Is it always roughly divisible by two?

Certainly the row counts are not over overflowing DTS's capacity.

Could it be that the file is incorrectly terminated on a number of rows?

Can you isolate a break?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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

It is always very close to 1/2. It doesnt stop on the same row when I split
the file. The first time I ran it, it imported 790,000 records. When I cut
the file down to 700,000, it stopped at about 355,000.

"Allan Mitchell" wrote: