Share via

SSIS: Using Proxy Account to Execute a Package

  • Article

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

http://1.bp.blogspot.com/-9ZXChXGqYLk/TpvYIikx9cI/AAAAAAAAAHE/IHw4PmbpPVo/s320/image007-758115.jpg

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

http://1.bp.blogspot.com/-Q4_JJNMUSo4/TpvYIjgJNEI/AAAAAAAAAHM/d81gW8gjNtg/s320/image008-758837.jpg

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

http://4.bp.blogspot.com/-X-bzbfvp2-w/TpvYI8OrqbI/AAAAAAAAAHc/ERkmZPMw7dA/s320/image009-759531.jpg

4.       Give some name to the credential being created

http://4.bp.blogspot.com/-gYHk1mt42hE/TpvYJXLNtoI/AAAAAAAAAHo/nB31sIuwP2k/s320/image011-761046.jpg

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

http://2.bp.blogspot.com/-pL0lWs9AY4I/TpvYJnHmaTI/AAAAAAAAAHw/lcXhMrgRigA/s320/image014-762056.jpg

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

http://4.bp.blogspot.com/-C2MyU9ubWhc/TpvYJvAQMmI/AAAAAAAAAIA/OJUQBxTL4VU/s320/image016-762813.jpg

7.       The credential is now created

http://2.bp.blogspot.com/-eUxyWKtvj_Y/TpvYKIAQzGI/AAAAAAAAAIM/v7K-nLn7uuU/s320/image025-764268.jpg

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

http://3.bp.blogspot.com/-t6MS-bhHhkg/TpvYKdbQLVI/AAAAAAAAAIU/EO7AxkUewYk/s320/image026-765108.jpg

9.       Give a name to your Proxy

http://2.bp.blogspot.com/-apMDIKh7VJg/TpvYKXjjIrI/AAAAAAAAAIk/NkyJds_z1i8/s320/image027-765936.jpg

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

http://3.bp.blogspot.com/-oRxRrPUT20w/TpvYKzGWakI/AAAAAAAAAIs/YI1WidAVveM/s320/image029-767456.jpg

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

http://1.bp.blogspot.com/-S_s2UtFyZ8k/TpvYLBnHqxI/AAAAAAAAAJA/ONJDFghSa8s/s320/image035-767956.jpg

2.       Give a name to the job

http://4.bp.blogspot.com/-yssbIs4DciI/TpvYLduFjuI/AAAAAAAAAJI/bX1XCedyP20/s320/image036-769723.jpg

3.       Go to steps Page and click on  New

http://2.bp.blogspot.com/-VibIcpkNpx0/TpvYLv8ewiI/AAAAAAAAAJU/u1N-fdyd2Lw/s320/image038-770263.jpg

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

http://3.bp.blogspot.com/-Uxcn3atOTkE/TpvYLzyamgI/AAAAAAAAAJg/-N-HsknRVoo/s320/image042-771244.jpg

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