Too many columns found in the current row; non-whitespace characters were found after the last defined column's data. ERROR
"Too many columns found in the current row; non-whitespace characters
were found after the last defined column's data."
SOLUTION
Try changing the "Row delimiter" field from {CR}{LF} to {CR} within the
"Select file format" dialog of DTS Import Data wizard (it's the 3rd
dialog of the Wizard).
REASON
I believe it has to do with the way a line of text is terminated under
UNIX vs. Windows because everytime I've encountered this error it was
while importing a text file downloaded from a UNIX FTP site.
LB
"Do not attempt to be all things to all people. Unless, of course,
you'd like to live your life burnt out, exhausted, and unappreciated." |