Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a table of this structure

create table test {
  id_data int identity,
  data text
  // id_data is the primary key
}

I used the following commands:

bcp DB..test out prod.bcp.out -U me-P pwd -SPROD -I ~/bin/interfaces -c -T40960
bcp DB..test in prod.bcp.out -U me -P pwd -SUAT -I ~/bin/interfaces -E -c -T40960

And the bcp in emits the following message:

CSLIB Message:  - L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
bcp copy in failed
share|improve this question

1 Answer 1

up vote 1 down vote accepted

I've had similar issues when bulk copying text field data. It's possible that you have characters in your data which are being misinterpreted by BCP as field or line delimiters.

Try explicitly setting field and line delimiters.

bcp DB..test out prod.bcp.out -Ume -Ppwd -SPROD -I ~/bin/interfaces    -t#@# -r\\n -c -T40960
bcp DB..test in  prod.bcp.out -Ume -Ppwd -SUAT  -I ~/bin/interfaces -E -t#@# -r\\n -c -T40960

I used #@# here because it was recommended here since it's more unique than the standard options (bars, commas, tabs, etc.).

share|improve this answer
    
I am not able to verify the answer because the 12.5 server has been retried. But your answer looks like a solution. –  Anthony Kong Feb 19 '14 at 0:12
    
I've just used this successfully in a migration from 12.5 to 15. –  Chad Kieffer Feb 19 '14 at 17:11
    
To be more specific, a cross-platform migration from 12.5 on *nix to 15 on Windows. –  Chad Kieffer Feb 19 '14 at 17:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.