Configure an SSIS Package to Execute as a Proxy Account https://community.spiceworks.com/how_to/129293-configure-an-ssis-package-to-execute-as-a-proxy-account If an SSIS package needs to execute with specific permissions, you can create a service account for it to use, and the developers can configure the packages to inherit the run as account so that they never need to know what the password is. Proxies can be used with just about any kind of SQL job step, not just SSIS packages. 8 Steps total Step 1: Create a New Credential Expand Create a credential under the server-level Security tab by right-clicking on the Credentials node and clicking New Credential... Step 2: Enter Credential Information Expand Enter a name for the Credential, the Windows account you want it to use as Identity, and enter the password for the account twice. Optionally, you can specify which encryption provider to use. Then click OK. Step 3: Create a New Proxy ...