The stored procedure you call to actually create the XML, what type of resultset does it return?

If you use the varchar data type, try replacing that with nvarchar.

Regards, Rob

Hi,

Looking at the error I would guess BCP is having trouble converting between codepages.

Could you try adding "-C RAW" to the BCP command line string and tell us what happens?

Regards,...

http://www.amazon.com

(or equivalent)

Seriously, while there are many sites containing small tutorials and such, if you really want to get off to a good start just order the material you...

Hi,

I'm not clear on the actual requirements you have for this "replication" mechanism, but if all you do is overwrite data each night, why not schedule a task that takes...