[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Error when importing 700 mb text file

Posted on 2006-06-19
6
Medium Priority
?
282 Views
Last Modified: 2009-07-29
When I import a 700 mb text file into sql, i get the following message:
Error at source row 577960. Too many columns found in the current row; non-whitespace characters were found after the last defined column's data.

Any advice on how to process this file successfully?
0
Comment
Question by:danielm28
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16935660
0
 

Author Comment

by:danielm28
ID: 16937879
I upgraded to sp4 and tried msft's other recommendations with no luck.
What else should i try?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16939036
Make sure your row delimiter matches the delimiter in the text file.  In other words, verify that the text file uses the same row delimiter (CrLf or Cr or Lf) as you have indicated in your DTS package.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

Author Comment

by:danielm28
ID: 16942966
I have went through and tried each and every row delimiter option to no avail.
What else do you recommend?

Thanks for your help.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 16944661
>>What else do you recommend?<<
You open the text file with a hex editor and verify what row delimiter it is using.
Verify that row 577960 does in fact have the right number of columns.
0
 

Author Comment

by:danielm28
ID: 16956316
I opened the file, removed some rows and then it worked fine.
Thanks.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question