cfmdev
asked on
SQL SERVER 2000 Bulk Insert question
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\ Content\fi les\Person alizedData Feed\Forma t\orderLin eItem.fmt' .
orderLineItem.txt
dataFeedTest75.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\
orderLineItem.txt
dataFeedTest75.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That did the trick...thanks kssaran.
Looks like collation name sepcified for Column 12 in your query doesn't seem to be matching with the original Collation name for Column 12.
Please verify the same.