I have a SSIS package which was failing to execute from a SQL Server Agent job with the following error:
Unable to start execution of step 1 (reason: JobOwner EUR\s2sqlhotelldb01 doesn’t have permissions to use proxy 8 for subsystem SSIS). The step failed.
I solved the problem by changing the owner of the job to the account
Continue reading […] Proxy permissions in a sql server agent job […]