ansaurus

Question

BCP: Unable to resolve column level collations

Answer 1

A:

You may try to remote connect to the server and run the bcp without the -s option from there.
If the server collation is different from the database or column collation, try to create the format file and explicitly specify it in the bcp.

Damir Sudarevic 2009-11-09 18:26:23

That might not be easy for me, but I might try that, and it might provide useful info (though I doubt it). Unfortunately I won't be able to run the process like that in production no matter what, so it won't help me in the long run, unless it somehow helps track down the real source of the problem.

2009-11-09 18:39:02

Good idea with the format file, but unfortunately I get the same error.

2009-11-09 18:54:51

What does it say for column format (see the xml) when you run this:bcp MyDB.dbo.uvwMyView format null -f c:\FMT_01.xml -x -c -T -t

Damir Sudarevic 2009-11-09 19:19:23

Annoyingly enough, I get the same error message. That is to say, I can't run the statement you mention. The way I made the format file I used in my previous test was to use an existing format file on a view that is the exact same format (selects from the same tables) and doesn't have this problem.

2009-11-09 20:26:20

Answer 2

A:

Dropping the view and recreating it fixed the problem. Unfortunately this doesn't explain how the problem happened in the first place, or how to prevent it in the future. This isn't a satisfying solution, so if anyone knows a better answer, I'm still very interested in hearing it.

2009-11-11 15:20:19

ansaurus

tags:

views:

answers:

BCP: Unable to resolve column level collations

related questions