June 5, 2014 at 7:09 am
Hi,
When I try to bulk load some files I get this error:
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)".
Can someone help?
Thanks.
P.S - I'm not using any linked server...
June 5, 2014 at 7:10 am
Do you have any carriage returns/line feeds in the file where they don't belong?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 5, 2014 at 7:17 am
What are carriage returns?
June 5, 2014 at 7:19 am
The character at the end of the line. You know, the one you get when you hit "enter" on your keyboard.
Can you share the bulk insert command you used?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply