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

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

"Brad" <nospam (AT) co (DOT) lane.or.us> wrote

Hi Brad,

Thanks for your posting!

From your descriptions, I understood that your big ASCII file have to be
seperated into small parts to make import smoothly. Have I understood you?
If there is anything I misunderstood, please feel free to let me know.

I found our development team had found this before internally. They think
it is by design and here is the comment
----------------------------------
upon more investigation we were able to get the exact row number where the
failure occurred. so after getting the exact row number we were able to
identify rows were informatted correctly and hence no bug. apparently when
i spit the file into 2 files, the problem rows probably were in the first 2
meg so file got imported.
----------------------------------

They have also notified that that offending row looks fine in notepad. As a
workaround, I think you'd better use BCP instead.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!