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'
Top Menu
6 comments:
Hey, that' really cleaver! Thanks a lot!
But when I see it this way there is only the details of the step but not exactly the package name.
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.
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
Post a Comment