Skip to Content.
Sympa Menu

freetds - [freetds] bcp -n -E fails on identity column

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Kendall <john AT capps.com>
  • To: FreeTDS Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] bcp -n -E fails on identity column
  • Date: Sun, 5 Jun 2016 08:56:43 +0000

Using the bcp -n (native file format) and -E (retain identity values) options
together produces:

Msg 20053, Level 4
Requested data conversion does not exist


I see this happening on Sybase (11 & 16) and MS SQL 2008.


Test to reproduce:

select id_col=identity(5) into tempdb..tbl -- Sybase
select id_col=identity(int) into tempdb..tbl -- MS SQL

$ freebcp tempdb..tbl out tbl.bcp -S $DSQUERY -U usr -P pw -n -E

Starting copy...

Msg 20053, Level 4
Requested data conversion does not exist

bcp copy out failed

datacopy also has a problem with the -E option, I assume the problems are
related.

John






Archive powered by MHonArc 2.6.24.

Top of Page