作者alfie0521 (不舒服)
看板Database
标题[SQL ] Bulk Insert成功，但仍有错误讯息?
时间Fri Jun 20 05:08:07 2008
请教一下，我用Bulk Insert将档案大小1GB，
档案格式为tbl的data set汇入资料库，
汇入完成後仍会出现错误讯息，但是资料却都成功汇入了。
已经成功汇入数个大笔资料的table了，都没有问题，
只是错误讯息会在汇入完成後跳出来，不知道错在那里？
(环境: SQL Server 2005 Express)
BULK INSERT
[CUSTOMER]
FROM 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Windows Data\
customer.tbl'
WITH
(
BATCHSIZE = 5,
CHECK_CONSTRAINTS,
CODEPAGE = 'RAW' ,
DATAFILETYPE = 'char',
FIELDTERMINATOR = '|' ,
FIRE_TRIGGERS ,
KEEPIDENTITY ,
KEEPNULLS ,
MAXERRORS = 10 ,
ROWTERMINATOR = '|' ,
TABLOCK
)
错误讯息:
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error.
The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server
"(null)".
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 68.202.24.147