How do you tell which account SSIS is using to execute a package
Thank you and happy holidays... :)Dave SQL Developer
December 15th, 2010 11:00am

Hello, Could anyone tell me how I can find out which account SSIS uses to execute a package? I am having permission issues... Any help would be appreciated Dave SQL Developer
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2010 12:10pm

you can create proxy account to run SSIS package under it: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/69441/http://www.rad.pasfu.com
December 15th, 2010 12:20pm

When you run it in SSIS, its under your account. You can query the System Variable called username to verify this. When you run it through SQL Server agent, it runs under the account setup to be used by SQL Server agent. Mostly the service account is the proxy account thats setup to run the agent.
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2010 12:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics