To run an SSIS package with specific permissions, you can create a service account and configure the package to inherit the run as account. This way, developers won’t need to know the password. However, proxies can also be used for any SQL job step, not just SSIS packages.
To create a new proxy, follow these eight steps:
Step 1: Go to the Security tab and right-click on the Credentials node. Click New Credential.
Step 2: Enter the name, Windows account identity, and password for the credential. Choose an encryption provider if desired.
Step 3: Right-click on the Proxies node and click New Proxy.
Step 4: Give the proxy a name, assign it the credential you created, and assign it to the SQL Server Integration Service Package subsystem. You can assign it to other subsystems later if needed.
Step 5: Optionally, add logins to the Principals tab to allow them to assign the proxy to job steps.
Step 6: Click OK to create the proxy.
Step 7: When creating or modifying a job step, set the Run as account to be a proxy account. You can only choose from proxies that were already assigned to the subsystem at the time the job step dialog was opened.
Step 8: Save the job step when finished.