I have a problem, I am in the process of moving jobs and packages to SQL 2005
and I have a DTS package on SQL Server 7 that has been scheduled into a job.
Unfortunately I have no idea what DTS package this job is running only an
encrypted package name in the DTSRUN command, unfortunately this is failing
with SQL Server does not exist or access denied.

What I need to do is decrypt the package name and establish whether the
package even exists. The problem I have only the details of the DTSRUN
command in the Job to go on and I have no history for the job as the agent
was set to record only 100 lines of history so I lost the history of this job
a long time ago, so I have no idea when this first started failing.

Can anyone help.

Thanks

Jonathon Blues

OK, did a bit more digging and found this gem to help partly, take the DTSRUN
string in the job and add /!X and /!C on the end then open a command line and
paste it in. Run the code then it will expose the name of the package name.
If you still get the error I am getting find the encrypted server name from
another working package and replace the server name in the text to that and
run again.

I still need to decrypt the server name though if anyone has any answers
please let me know.

"Jon Blues" wrote: