April 28, 2007 at 7:43 pm
Hi,
I seem to get the "Too many columns found in the current row; non-whitespace characters were found after the last defined column's data" when importing from a text file (delimited with vertical bar as column delim and CR LF as row delim).
When I split the file into two, i dont get the error and the individual files are imported without any problems.
The original file has 100,000 records and the fail was saying Error after 89000 records, so I split into 88000 and 12000 record files and they loaded successfully.
When analysing with UltraEdit i couldnt see any difference in the end of the row on 89000,89001,88999,89002..all ended with 0A and 0D characters (HEX).
ANy ideas why this would happen?
On the original i tried to change the row delim to just CR and it still gave me the error.
Does anyone know why this may happen that the original file fails but the split files work?
Thanks a lot
May 1, 2007 at 5:29 pm
Not sure what's going on, but one way to get some more information would be to go to the Options tab of your data transformation's properties, entering a path for the Exception File, and setting Max Error Count to a number > 0.
Run the transformation and look at the exception file.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply