FORMATFILE = '\\cdrexch1\shared\ScannedImages\AlliedInventoryMa ster.fmt'
I get the following error:
Cannot perform bulk insert. Invalid collation name for source column 1 in format file '\\cdrexch1\shared\ScannedImages\AlliedInventoryMa ster.fmt'.
What seems to be happening is the space that is in the column name of the .fmt file. If I replace Allied Stk # with another column in the table, URL, then it works correctly. Both fields are varchar 255 columns.