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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Nasty Error....

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 Laubert
MCDBA, MCITP:Administration, MCT
Go to Top of Page

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-2007
19-Mar-2007
23.99
08-Mar-2007
66.64
5.88
24.93
10-Mar-2007
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-20 : 13:30:02
TYou probably have a description field that allowed for free form text and the "data" contains tabs in it.

What's the data source?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -