We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below).

We tested on our test database exporting the table content to a file, then importing it in again immediately, but that failed too. e.g.,

bcp TABLENAME out ~/tempfile -S servername -U username

generates a file as expected. If we use -c option then the number of lines is as expected.

However,

bcp TABLENAME in ~/tempfile -S servername -U username

fails with

CTLIB Message: - L0/0D/S0/N0/0/0:
blk_int(): blk_layer: CT library error: Cannot find an equivalent CS_TYPE for this TDS data type  49
blk_init failed.

We get this whenever we try to copy into TABLENAME, whether from the production or test table dump file.

I don't understand why export and import for the same TABLENAME is generating a data type error. What am I doing wrong here?

Thanks