DTSRun Encrypted

In a Multi Server Job under SQL Server Agent (MSX), we have a series of
steps like:

DTSRun /~Z0x8E8635E6BBA...

The ~Z means it's an encrypted hexidecimal string. The person who created
this step is no longer accessible, and the string can't be trivially
decrypted, so I don't know what this runs.

Someone once mentioned that I could go to Query Analyzer, run it, and
watch the execution plan. However, if I start the job, the execution
plan simply walks through the steps required to find the job, and doesn't
go into the details of the job. I don't know how to run the DTSRun
command directly within Query Analyzer.

Is there a way I can use the execution plan to determine what package this
DTSRun line is executing? Please give me the appropriate command or
commands.

-AdamIn theory you could do this using profiler, I have never tried it though...

All DTSRun does does is call the loadpackage and then executepackage methods
on the DTS.Package object, as long as the package is a SQL Server package
and hence gets loaded out of msdb the calls to the sp's in msdb should show
up

"Adam Augusta" <roxton@.wpi.edu> wrote in message
news:Pine.LNX.4.58.0309191701430.27905@.ccc8.WPI.ED U...
> In a Multi Server Job under SQL Server Agent (MSX), we have a series of
> steps like:
> DTSRun /~Z0x8E8635E6BBA...
> The ~Z means it's an encrypted hexidecimal string. The person who created
> this step is no longer accessible, and the string can't be trivially
> decrypted, so I don't know what this runs.
> Someone once mentioned that I could go to Query Analyzer, run it, and
> watch the execution plan. However, if I start the job, the execution
> plan simply walks through the steps required to find the job, and doesn't
> go into the details of the job. I don't know how to run the DTSRun
> command directly within Query Analyzer.
> Is there a way I can use the execution plan to determine what package this
> DTSRun line is executing? Please give me the appropriate command or
> commands.
> -Adam