Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-03-13 : 08:27:24
|
| 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. |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-16 : 12:05:59
|
| 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.Raymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-03-20 : 10:51:54
|
| 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..Example:09-Mar-200719-Mar-200723.9908-Mar-200766.645.8824.9310-Mar-2007 |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Nasty Error....