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'

6 comments:

  1. Hey, that' really cleaver! Thanks a lot!

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

    ReplyDelete
  3. 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.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Sanssql ,this is good place for developers .so many things here to be learned it is useful blog for the developer ,designer they can learn from here so many thing my sql and database . I am very glad to be here ,I appreciate these types of struggle .great Find a job in London

    ReplyDelete