Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Nasty Error....
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

443 Posts

Posted - 03/13/2007 :  08:27:24  Show Profile  Reply with Quote
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.

Yak Posting Veteran

96 Posts

Posted - 03/16/2007 :  12:05:59  Show Profile  Visit rlaubert's Homepage  Send rlaubert a Yahoo! Message  Reply with Quote
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

Constraint Violating Yak Guru

443 Posts

Posted - 03/20/2007 :  10:51:54  Show Profile  Reply with Quote
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..

Go to Top of Page

Not Just a Number

15586 Posts

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

What's the data source?



Hint: Want your questions answered fast? Follow the direction in this link

Add yourself!

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000