Solved

Error when importing 700 mb text file

Posted on 2006-06-19
6
271 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

831 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