Problem: Too many columns found in the current row; non-whitespace -- sql server dts

Brad
9/14/2004 9:21:26 AM

Attempting to import from an ascii file I'm receiving the following error
Too many columns found in the current row; non-whitespace
The problem is that I examined seeveral of the lines reported as bad and
there is nothing wrong with them.
The original ascii file size is 77mb and 163169 rows....279 rows throughout
the file are being reported as bad. If I try a smaller ascii file, which
is subset of the data, which includes many of the "bad" rows they all
import successfully.

Running SQL2000 sp3
ascii file rows are cr/lf delimited
columns are | delimited
no text qualifier (and | is not embedded within any text)

Brad

Brad
9/14/2004 11:19:45 AM

Update - If I break up the one large ascii file into several smaller files
I can import all of the rows successfully, without any errors. It would
seem that dts has a buffering problem.

Brad

[quoted text, click to view]

sql server dts : Problem: Too many columns found in the current row; non-whitespace