Bulk insert EOF error on file
Posted on 2004-09-16
I am getting this error when trying to load a csv comma delimited file:
Server: Msg 4832, Level 16, State 1, Line 1
Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].
The statement has been terminated.
I am wondering if I have something wrong in my insert statement
BULK INSERT DOCSDB..Temp FROM 'c:\SER\new\import.csv'
FIELDTERMINATOR = ',',