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
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.