June 3, 2013 at 7:52 am
Hello All,
Currently trying to insert a data from a file placed in a remote server and using the BULK INSERT command to perform the same, but I am getting the error "Operating system error code 5(Access is denied) when i use the bulk insert command.
Login already has bulkadmin privileges and able to access the file in the remote server from my source server.
I am able to perform the import operation when i use the import /export wizard.
Why is it so?
June 3, 2013 at 8:18 am
Please try with UNC path of file location in bulk insert .
June 3, 2013 at 8:44 am
Also make sure the login has permission to access the format file in its location on the server.
June 4, 2013 at 3:27 am
Regardless of Login, your SqlServer Service Account will require NTFS and share permissions to the UNC path. Have these been set up?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply