Re: bcp -n -E fails on identity column
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4c58-+xiK=xumphddsHk7VLfVPbMCUwHP+RLxaq1TGKmw@mail.gmail.com> |
On 5 Jun 2016 09:56, "John Kendall" <[email protected]> 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