SSIS SQL Server Agent access denied. Job proxy?
Posted on 2015-01-06
I need some good clarification on this and the easiest way to handle it. Created an SSIS dtsc package with dtsconfig file with connection strings etc. runs fine when i execute the package. Added a sql job via the agent as ssis package pointing to the file and when it runs says access denied. What is the best way or easiest way to handle fixing this? If I get a service account do I setup a job proxy and what do I do to set that up as far as do I also have to open the dtsx in bis and change anything for permissions etc. Credentials always the biggest headache with this stuff. Thanks for any info all.