June 15, 2004 at 8:33 am
I have a number of DTS packages that are run via scheduled jobs. The problem being that the job steps call the packages as follows:
DTSRun /~Z0xEDFDEE9CB373D2237FD...........etc.
Is there a quick way to map this id back to the job name so i can see which jobs are calling which packages?
cheers
June 15, 2004 at 9:00 am
If you right clicked on the package and selected the schedule package option then you'll find that the job name is the same as the package name.
I prefer to use the dtsrun with switches to call the package by name ( DTSRUN /Sservername /N"Package Name" /E ) Check out BOL for DTSRUN.
June 15, 2004 at 9:26 am
Thanks Nicholas - I see what you mean. However if the job and steps have had their names changed it doesn't match. I was also hoping for a more automatic way rather than right clicking each package.
cheers anyway
June 15, 2004 at 10:04 am
The /~Z indicates that it's an encrypted hex string, which probably relates to either the package name or the package guid.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply