running32
asked on
Bulk insert EOF error on file
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
go
BULK INSERT DOCSDB..Temp FROM 'c:\SER\new\import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR ='\n'
)
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
go
BULK INSERT DOCSDB..Temp FROM 'c:\SER\new\import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR ='\n'
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.