Am getting this nasty error i call it nasty as i can't see what causing the problem...
Here is the error log replrt.. there does not seem to be any change made to my txt file i've looked at the failing row when i test the transformation and for the life of me i can see any differences..
Error: 0 (0); Provider Error: 12307 (3013) Error string: Too many columns found in the current row; non-whitespace characters were found after the last defined column's data.
What kind of delimiter are you using? Can the data have that character in it. Had this type of problem using CSV and single quotes. Name field had a quote in the last name. Messed stuff all up until I found it.
My problem is that am getting the wrong data in the worng colums after the import. See example for my date column am getting numbers but am doing the mapping correct i feel its the file, this is only a recent problem as it was working before ok. Extract file is ttx file and then i rename it to .txt file, its format is Tab separated Text and it has "" in it that i have to remove as they come into the database field also..
Nasty Error....
Posted - 03/13/2007 : 08:27:24
