How do I import this txt file in SQL Server?
Posted on 2007-08-07
I have a large txt file (107 million rows), that has fields that are tab delimited, and lines that are linefeed delimited. It is from MySQL. Anyways, I try to import this file into SQL Server through the Enterprise Manager, and nada, it quits out with a too many columns found error on row 5,212,342. How do I import this file into SQL Server, and have it ignore any errors that could occur?
Please provide me with an example on how to do this.
Worth 500 points.