Skip to Content.
Sympa Menu

freetds - Re: [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: Re: [freetds] bcp -n -E fails on identity column
  • Date: Wed, 22 Jun 2016 15:01:05 +0000

My last attempt to report this was a bit muddled. Here's another try.
Using version 1.00.6.

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

Msg 20060, Level 11
Unknown datatype encountered

Error in bcp_colfmt col 1


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
Msg 20060, Level 11
Unknown datatype encountered

Error in bcp_colfmt col 1

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