Categories
SQL / Stored Procedures SQL Server 2000

Cannot perform bulk insert. Invalid collation name for source column 1 in format file ‘C:bcp.fmt’.

It took me a while to finally figured what what went wrong to fix the above error. The problem is my bcp.fmt needs to have an empty line at the last row.

bcp

The first screen capture is the one before I added the empty line and the second screen capture is the one after I added the empty line. Take note of the cursor.

After you have added the empty line, it should works.

3 replies on “Cannot perform bulk insert. Invalid collation name for source column 1 in format file ‘C:bcp.fmt’.”

I’m glad I found a homepage that deals with the same thing I’m dealing with. I always read the whole article and keep an eye on other comments too before commenting myself. In this way i have found some good Blog that I now follow beyond the purpose of getting links from them. For example, this is my sixth stopping over your site. I always love the content and the way you write .

Leave a Reply

Your email address will not be published. Required fields are marked *

*