用bcp导入时,报如下错误:


Starting copy...
CTLIB Message:  - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 6
CTLIB Message:  - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 6
CTLIB Message:  - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 6
CTLIB Message:  - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 6
CTLIB Message:  - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 6
CTLIB Message:  - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 6
CTLIB Message:  - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 6

bcp copy in failed

0 rows copied.
Clock Time (ms.): total = 125

 

存在原因:数据库中表的字段不能为空,并且没有默认值,但bcp里第6列有为空的值。

所以无法插入记录。

posted on 2009-03-25 10:06  sky100  阅读(1540)  评论(0编辑  收藏  举报