[SQL ] Bulk Insert成功，但仍有錯誤訊息?
請教一下，我用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
Database 近期熱門文章
PTT數位生活區 即時熱門文章
