Tuesday, January 1, 2008
How to find DTS package Name from JOB step
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'
Labels: SQL Queries