Re: bcp -n -E fails on identity column
John Kendall <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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