Steve Ngai (危 志 荣) KuaLa Lumpur, Malaysia

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.

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.