I am attempting to do a bulk insert but am getting a collation error. If someone could review my .fmt file and text datafile and point me in the right direction to fixing...that would be great...note...the .fmt file has been rename to .txt due to file restrictions...it has been changed from orderLineItem.fmt to orderLineItem.txt.
Here is the error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot perform bulk insert. Invalid collation name for source column 12 in format file '\\server\test\SAN\client\