I am trying to import a pipe delimited file in a DTS package. I am getting
the error "Too many columns found in the current row; non-whotespace
characters were found after The file I am trying to import is only 12 rows
with 1 row of header information. I have noticed that this is a bug when you
are loading a fixed field length fiel, but this is not the case here. I have
checked the file and everything appears to be fine. Any suggestions?

Thanks

In message <1A065665-4E80-44E8-A702-6B15FE890EE2 (AT) microsoft (DOT) com>, Andy
<Andy (AT) discussions (DOT) microsoft.com> writes
If the format is valid, then pipe is a valid delimiter. Try taking out
the header row to design and test the transform. Leave the skip rows /
header row option on though.

Then swap in the real file.

The design time stuff still reads the header row and gets confused, but
at run-time it will just skip it.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org