DTS package name question

[MrHelpMe]

I need some help if possible.

I have four different dts packages that are very close in naming ie

SA_Update_Client01
SA_Update_Client02
SA_Update_Client03
SA_Update_Client04

and I have SQL Agent job that invokes one of these DTS but when I attempted to troubleshoot I don't know which DTS is being invoked as the command in the SQL jobs step is DTSRun /~Z0x3929482D2659D7B444444. So the question is how do I know which DTS package this command relates to. Thank everyone.

 

[nigelrivett]

That's encrypted. You have probably added the job from enterprise manager by scheduling it - the name should be in the description.
I code the dstrun's manaually so that I know what is being run.

You could adding further entries from enterprise manager and see what the encrypted values are.
Try running it and see what is run?




======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.