Re: [GRAYMAIL] bcp -n -E fails on identity column
John Kendall <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
> On Jun 5, 2016, at 5:12 AM, Frediano Ziglio <[email protected]> wrote: > > 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? 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 > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds