how to fix bulk insert issue

Question

cannot bulk load because file "\mynetwork\fiel\myfile" could not be opened. Operating system error code 5 (access is denied)
my job which bulk inserts from the above mentioned source used to work fine. But lately, I see this error. Nothing has changed from SQL server side. If I ran the code from ssms it yeilds an output but the job fails by throwing the error I wrote above

Answer 1

That is the classic access issue. the job agents run with a different user. go to the SQL configuration manager to see which user is being used for running the SQL agent. Then, give access to that user—simply said than done. so I suggest another way. first, go to the network link to the file you are using for upload. give that path/file the 'everyone' access and run the job, if this fixes the issue then it's an access issue. so now you only need to give access to the user from which the job agent is running.