Map a job to a DTS package

• Roust_m

  SSCoach

  Points: 17410

  More actions

  January 30, 2007 at 4:17 pm

  #172099

  Hi,

  I have some legacy jobs which run DTS package like this:

  DTSRun /~Z0x938B5DC72FA7E513BD ...

  Is there a way to map this magic number to the DTS package name?

  Thanks.

   

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  January 30, 2007 at 4:30 pm

  #686646

  Unless someone changed the job name, the job name itself matches the DTS Package name.

  -SQLBill

• Roust_m

  SSCoach

  Points: 17410

  More actions

  January 30, 2007 at 4:47 pm

  #686650

  If the job name matches the DTS name this is easy.  What if it is not or the call to run a DTS package sits in a job step not giving any hint about the DTS name?

• Christian Buettner-167247

  SSChampion

  Points: 13729

  More actions

  January 31, 2007 at 12:38 am

  #686736

  Hello,

   

  this should give you the information you need:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=194277

   

  Cheers,

  Chris

  Best Regards,

  Chris Büttner

• Carlos Urbina

  SSCommitted

  Points: 1850

  More actions

  January 31, 2007 at 9:05 am

  #686881

  Also consider the following:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=232301

  I especially appreciated Jeet's stored proc that runs a package. But LS hit it on the nose, for he said, "....take a look at the variable @description. It should state the package name that the job is executing, like this: @description = N'Execute package: XXX'".