Solved

Error when importing 700 mb text file

Posted on 2006-06-19
6
273 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

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

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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 to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

695 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