How to find DTS package Name from JOB step | SansSQL

Tuesday, January 1, 2008

How to find DTS package Name from JOB step

To find the Name of the DTS Package from Job step, do the following

Right click on the job and click on Generate SQL Script. Click the Preview button and look at the preview for the line:
--Add the job

Now take a look at the variable @description. It should state the package name that the job is executing:
@description = N'Execute package:Test'


Anonymous said...

Hey, that' really cleaver! Thanks a lot!

anita said...

But when I see it this way there is only the details of the step but not exactly the package name.

Sandesh Segu said...

Hi Anita,
You have to look at the code where it says -- Add the job...
In the block of code you will get the package name.

Post a Comment