February 17, 2014 at 11:07 pm
I saw the correct extension and changed but now am getting the error
Cannot bulk load because the file "E:\BEM_Data\Test\GSP_EVENT_DATA_16.csv" could not be opened. Operating system error code 21(The device is not ready.)
February 18, 2014 at 1:46 am
mandir.jain (2/17/2014)
I saw the correct extension and changed but now am getting the errorCannot bulk load because the file "E:\BEM_Data\Test\GSP_EVENT_DATA_16.csv" could not be opened. Operating system error code 21(The device is not ready.)
Error code 21 is a generic code from the OS, generally for an I/O error.
Now that we know it's a csv file - have you managed to open it with a text editor?
February 18, 2014 at 2:02 am
Of course I can open the file
February 18, 2014 at 4:54 am
The account SQL Agent is running under - are you sure it has permissions to the file?
And is E:\ still a local drive, or now a Network Drive location?
If you set up a proxy so this job runs under your credentials (you can open the file), it should verify if it is a permissions issue.
February 18, 2014 at 5:04 am
Like Greg said, the account being used to access the file must have permission to the file. I know this sounds like an altruism, but it sounds like the piece of the puzzle that's missing.
The bulk insert command is documented at http://technet.microsoft.com/en-us/library/ms188365%28v=sql.100%29.aspx.
February 19, 2014 at 10:10 pm
While using bulk insert am getting following error
Please tel me how to resolve 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)".
February 24, 2014 at 10:47 pm
While using bulk insert ,am getting 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)".
how to resolve this error? Any help will be appreciated:-)
Viewing 7 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply