Scheduled Package Name

• beath

  SSCrazy

  Points: 2939

  More actions

  June 15, 2004 at 8:33 am

  #163899

  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

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  June 15, 2004 at 9:00 am

  #510478

  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.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• beath

  SSCrazy

  Points: 2939

  More actions

  June 15, 2004 at 9:26 am

  #510486

  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

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  June 15, 2004 at 10:04 am

  #510494

  The /~Z indicates that it's an encrypted hex string, which probably relates to either the package name or the package guid.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net