Thursday, February 21, 2013 1:54 PM
I TRIED TO PERFORM A BULK COPY BUT HAVING SOME PROBLEMS
ERROR: Cannot bulk load because the file "\\SRV-NAME\FOLDER1\FOLDER2\FOLDER3\EX20130221123251.txt" could not be opened. Operating system error code 5(Access is denied.).
PERFORMING THE SAME BULK COPY WHEN I MOVE THE FILE TO 'c:\\EX20130221123251.txt' DIRECTORY IT WORKS FINE.
NB: FOLDER1 IS A SHARE FOLDER FROM THE SERVER THAT I TRY TO ACCESS FROM MY SQLSERVER INSTALL ON MY PC.
Thursday, February 21, 2013 5:31 PMAs error message says,do you have access to the share path?
Thanks, Sohail ~Please mark answered if your question is completely answered; vote it as helpful to help others find a solution quicker. This posting is provided AS IS with no warranties.
- Proposed As Answer by Papy NormandModerator Thursday, February 21, 2013 6:00 PM
Friday, February 22, 2013 8:25 AM
First try to understand how security flow in sql server works
Though this is meant for how security flows in SQL Server agent, when TSQL scripts are running directly from SSMS, the same rules apply.
- Marked As Answer by Iric WenModerator Friday, March 01, 2013 8:26 AM
Sunday, February 24, 2013 1:44 AMModerator
When you say BULK COPY, do you mean the T-SQL BULK INSERT statement? In that case, ensure the SQL Server service account has permissions to both the share and underlying folders/files.
Dan Guzman, SQL Server MVP, http://www.dbdelta.com
- Marked As Answer by Iric WenModerator Friday, March 01, 2013 8:27 AM