View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 07:55 PM
lbunet@yahoo.com
 
Posts: n/a
Default 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."

Reply With Quote