Identify DTS package

[RobertT687]

Is there any way to determine which DTS package is being run from the encrypted command? I know the /~S refers to the server and /~N is the package name, but how can I translate the encoded name back into the package name?
ie:
DTSRun /~S 0xEC4F1686388C57C7068EDDF19740834D /~N 0x286B0C235EF79F523C235548339DC08C63514416D3A53CB30202ADD55F06B261AE2E62898A052446C5D6CDFC9D784577DB1E8AC07B55BBBECDF94981BF51E547 /E

I'm trying to debug a multi-step job and the above is what is in the problem step. The original developer is not available.

 

[nigelrivett]

Not easily - that's why you shouldn't allow encrypted commands. I assume someone has changed the description?

You could try removing packages until it fails if you know the location of the package.

======================================
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.

 

[RobertT687]

Thanks nigelrivett.
That may be the route I have to take.