DTS package

Question

DTS package

Farid Nia

SSC Rookie

Points: 32
More actions
February 12, 2008 at 3:18 pm

#179186

I have a DTS package that I have no idea which job runs it. The DTS must have been scheduled thru DTS and not DSTRUN /S {servername}. How can I find out what job runs which DTS

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

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

I can think of a couple of ways to approach this. The first way is to look at the creation date and time of the package logs and compare that to the rundate and time of the jobs.

The second way is to script out all the jobs into a single file, open it in a editor like Notepad, and search for the package name. If the package was scheduled in Enterprise Manager, the RUNDTS command will be encrypted.

To decrypt a DTSRUN command as used in a job step, copy the command to a cmd prompt,

append /!X /!C to the end, and run it. The !X argument blocks execution of the package

and the !C argument copies the unencrypted command to the Windows clipboard.

Just open Notepad and paste to see the unencrypted command.

Example:

DTSRun /~Z0x5F473BFAEEC0EE48EAF6121A88792F925A32FAF162A18E19FB06C5246A4CA2785EE38A17F0A6101B17B16C8F336C65EBF62B0E624C1E9B83 /!X /!C

Greg

Farid Nia SSC Rookie Points: 32 More actions · Answer 2

Here is the problem all I have is a DTS and want to know which job actually has the step to run the DTS. There are so many jobs and DTS, so didn't want to go each job and run the DTSrun command for each one. Is there a way to tie let's say the DTS name to a job id. Unfortuantely not everybody stays consistent with naming DTS and Jobs descriptive enough that you could tie them together. I would think someone else has had this problem before. Thanks so much for your help

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

There's no "cross reference" for packages and jobs. You can't tell what executes a package by looking at the package itself, so you'll have to look at the jobs. I think your best bet is to script out the jobs like I described. In Enterprise Manager, you can script all jobs to a single file.

Greg

Farid Nia SSC Rookie Points: 32 More actions · Answer 4

Farid Nia

SSC Rookie

Points: 32

February 19, 2008 at 8:59 am

#779772

Thanks, I will

CGSJohnson SSCertifiable Points: 7208 More actions · Answer 5

How about turning on logging for the DTS package and then matching up its execution time with the execution time of one of your jobs? Might work. Thanks.

Chris