How to schedule SSIS package to run as something other than SQL Agent Service Account

Question

In SQLServer 2005, is it possible to schedule an SSIS package to run something other than the AQL Agent Service Account?

I've got an SSIS package that makes a connection to a db and runs a stored procedure. My criteria is that I will not specify user names/passwords in a package or package configuration, so I want to use integrated authentication.

The problem is that be default a step in a job runs as SQL Agent Service Account, and our server group does not want to grant that account execute rights on the stored procedures that my package will execute. So we're trying to find a way to specify a different account in the step, so the package will run under a different context. is that possible?

Answer 1

http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx or http://msdn.microsoft.com/en-us/library/ms403355.aspx

might help

Answer 2

If you want to execute the SSIS package from SQL Agent jobs, then you can create a proxy. Check here for more information.