Thanks for the post.

Ken,

Thanks for the post - can't change the schema as it's our ERP solution.

Will have a plan with union queries.

Regards,

Simon

It's so obvious it's frightening!

The call to DTSRun from xp_cmdshell is under the context of the Agent Proxy. When the stored procedure executes DTSrun hooks into the ODBC connection however...