1) (Security -> Logins) Have a login with appropriate permissions
2) (Security -> Credentials) Create a credential and associate it with a Domain account
3) (SQL Server Agent -> Proxies) Create a new proxy and associate it with the new Credential
Under “Activate the following subsystems”
a) Select “Operating System”
b) Select “SSIS package”
4) (Security -> Logins) Select properties of our user and check “Map to credential” and add our credential
5) (SQL Server Agent -> Jobs) Select properties of your job then select steps and then edit and under Run As select our new credential
No comments:
Post a Comment