sorry for early posting:-D,

this article has helped me..

http://www.sqlservercentral.com/articles/Test+Data/61572/

thanks Jeff

thanks all, the csv file that I uploaded yesterday is full file. the problem is after the column name, one row with another row are separated by a comma, giving...

I was trying to do not use DTS wizard, and use bulk insert lg attachment bellow, but it is not solve anything...:-D

Jeff Moden (9/14/2011)

---

That doesn't match any of the previous errors you listed. The error above is what you might get if part of the file got chopped off... like...

this is screenshot for error:

Jeff Moden (9/13/2011)Errors 2, 3, and 4 are caused by error 1. What delimiter ARE you trying to use for a row delimiter? I can tell you that...

thanks ron for you comment, but the file size is just 907KB and it is CSV file. (not virus file, just txt/flat file)

don't worry about this file, and thanks for...

Jeff Moden (2/14/2011)

---

Ah... first problem I see...

Why are the "empty string" inventory numbers in the Inventory table? Without a proper inventory number on those rows, the amounts mean...