bulk insert: 出现Column is too long in the data file for row 错误信息?
羽盛 2005-12-29 11:28:07 我现在通过ADO.NET执行 下面的SQL语句
BULK INSERT xxx.dbo.REPORT_TBL
FROM 'logdata0.txt'
WITH (BATCHSIZE=10000,
DATAFILETYPE='char',
FIELDTERMINATOR='\t',
MAXERRORS=100000)
可以执行成功 。
但为了提高效率,把DATAFILETYPE='widenative' , :
BULK INSERT xxx.dbo.REPORT_TBL
FROM 'logdata0.txt'
WITH (BATCHSIZE=10000,
DATAFILETYPE='widenative'',
FIELDTERMINATOR='\t',
MAXERRORS=100000)
却发生下面的错误:
Bulk Insert fails. Column is too long in the data file for row
1, column 1. Make sure the field terminator and row terminator are specified
correctly.OLEDB provider STREAM' reported an error. The provider
did not give any information about the error. The statement has been
terminated.
不管怎样调整数据文件的字段格式, 都不行?