Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .