I was able to resolve BCP issue. Here are few observations (for Windows client):
For BCP out operation, use "Row Seperator" as "\r\n" ==> i.e CRLF For BCP in operation, use "Row Terminator" as "\\n" ==> Please note extra backslash For BCP in operation, use "Encoding" as "" I hope it will help.
Just to add more information:
I'm getting following error:
++++++++++++++
Server Message: dev1 - Msg 4847, Level 16, State 1:
BCP insert operation is disabled when data size is changing between client and server character sets. Please use BCP's -Y option to invoke client-side conversion.
++++++++++++++
I'm able to load the same file using bcp command.
I was able to resolve BCP issue. Here are few observations (for Windows client):
For BCP out operation, use "Row Seperator" as "\r\n" ==> i.e CRLF For BCP in operation, use "Row Terminator" as "\\n" ==> Please note extra backslash For BCP in operation, use "Encoding" as "" I hope it will help.
