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.
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’.”
Hi Steve,
You are right. I tried your solution and it worked for me.
Thanks a lot
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 .
Hi, thanks for comment even though my blog has been not too active recently. 🙂