I have the package level security set to "Dontsavesensitive", before I had it set at default "Encryptsensitivewithuserkey". Yes welsh, I have already crossed lots of bridges in trying to solve...

Thanks for the help Ken, I followed what you proposed, I was able to add the user and give it full control so that I don't have to worry about...

Hey welsh, I can see the files and open the files when I'm logged on as myself, although I do not know how I would log on to SQL Server...

Thank you so much guys, I will try the last two things and get back to you in a few minutes.

I think you might have welsh, but to be honest, unless I see it being done with examples it might not apply totally to my situation. Plus I'm just wondering...

Could you please give me a path to do this i.e. "Go to the server>SSMS>Right click on the server> select on permissions in "Server properties" If you could give me...

Thanks for the quick response steve, what process should I go through to make sure that the SQL Agent service account or the proxy account has the correct permissions to...

Hey Ken, that was how I had it previously, but the last two pictures that I uploaded, I show the file in the server where I'm running the job from....

Hey Steve, I'm the Admin to the server and I added my user specifically with all the user rights to run the jobs. Is there something else I should check...

Yes, I do have a network admin that could help me on permissions. You think that the network admin has to be involved with this issue even though I'm the...

I'm still getting the same error even after setting the appropriate permissions with the video link you sent me. I have attached a picture to show the error that I...

Thanks welsh, I was waiting to hear back from you. I will try both links and get back to you in a bit with the results. Thanks again welsh.

Hey welsh and syed, apologies for the late reply, but can you guys guide me as to the process to do this? I'm not sure how to do that, I've...

I am sysadmin on the Server, so I have SA privileges to everything. I do log into the server that runs the job and run the job manually and through...

Yes Jessie, selecting one column will always be faster than selecting the entire table.

select * from Mytable vs select [hello] from Mytable will return back results quicker. 🙂