Map a job to a DTS package

Question

Post reply

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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

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

-SQLBill

Roust_m SSCoach Points: 17410 More actions · Answer 2

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 · Answer 3

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 · Answer 4

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'".