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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] bcp -n -E fails on identity column
  • Date: Sun, 5 Jun 2016 13:12:48 +0100

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?

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page