Skip to Content.
Sympa Menu

freetds - Re: [freetds] [GRAYMAIL] 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] [GRAYMAIL] bcp -n -E fails on identity column
  • Date: Sun, 5 Jun 2016 17:15:34 +0000


> On Jun 5, 2016, at 5:12 AM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
>
> On 5 Jun 2016 09:56, "John Kendall" <john AT capps.com> wrote:
>>
>> 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
>>
>>
>
> Which FreeTDS version are you using?

Sorry, those error messages came from an old v0.95.19 install.

Using version 1.0, the bcp still fails, but with this message:


Msg 20060, Level 11
Unknown datatype encountered

Error in bcp_colfmt col 1



>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page