Execute one SSIS Package from Another, but using a DIFFERENT proxy user. Is it possible?

I have one SSIS Package that must run as Proxy A and another that must run as Proxy B. I would love to have the first package 开发者_运维问答run, and, as one of its tasks, execute the second package. Is this possible?

Thanks a lot!

You could have the first package use sp_start_job to kick off a job that is set up to run the second package. If this is "fire-and-forget", that's all you need to do. If you need to wait until it's completed, things get more messy - you'd have to loop around calling (and parsing the output of) sp_help_jobactivity and use WAITFOR DELAY until the run completes.

This is also more complex if you need to determine the actual outcome of running the second package.