[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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