Monday, 17 October 2011

SSIS : Using Proxy Account to execute a Package

Sometimes we need the package to execute with the credentials and rights of a certain user and we don’t want the Integration Services to be executed through that user. So in such a case we can use a proxy account to execute the package. The use of proxy account is not limited to just the SSIS packages we can use it for other tasks as well. Let’s see how can we create a proxy account.
1.       Open the SQL Server Management Studio

2.       Login to the server on which you want to create a proxy account

3.       Select New Credentials by right clicking on Credentials under Security

4.       Give some name to the credential being created

5.       Select the user or type its name in the Identity Box

6.       Enter the password for the selected user and Hit OK

7.       The credential is now created

8.       Now right click SSIS Package Execution under Proxies in SQL Server Agent and select New Proxy

9.       Give a name to your Proxy

10.   Select the credential ‘Admin’ created earlier and then select the role for the proxy and Hit OK

So now the proxy has been created, lets configure a SSIS package in a job using this proxy.

1.       Create a new job by selecting New Job after right clicking Jobs under SQL Server Agent

2.       Give a name to the job

3.       Go to steps Page and click on  New

4.       Now select ‘Admin’ in Run As and schedule the package

5.       And it’s done the job will be executed using the credentials of the selected user.

1 comment: