• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Error when importing 700 mb text file

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
danielm28
Asked:
danielm28
  • 3
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
danielm28Author Commented:
I upgraded to sp4 and tried msft's other recommendations with no luck.
What else should i try?
0
 
Anthony PerkinsCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
danielm28Author Commented:
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
 
Anthony PerkinsCommented:
>>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
 
danielm28Author Commented:
I opened the file, removed some rows and then it worked fine.
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now