bcp时出错

zujuhu

CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 4 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 4 row = 197032.
333000 rows sent to SQL Server.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 6 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 4 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 7 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 4 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 4 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 4 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 7 row = 197032.
CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routi
ne - condition overflow.  col = 4 row = 197042.

上面是出错信息，是什么导至的

tedy

溢出了，比如你向tinyint里倒入一个大的整数，另外SYBASE里的SEQUENCE也容易溢出。你把数据打印出来核对一下表结构就知道了。

斌子

怎么办？

Blackrose

1. 核对一下两边的表结构！
2. 换一种数据导出导入方式，比如把-c 换成 -n

llt

-c是字符方式
-n是什么呢