SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

rookie_sql
Constraint Violating Yak Guru

Ireland
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.

rlaubert
Yak Posting Veteran

USA
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

rookie_sql
Constraint Violating Yak Guru

Ireland
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..

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 - 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?



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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000