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'

6 comments:

Anonymous said...

Hey, that' really cleaver! Thanks a lot!

Unknown 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.

Unknown said...
This comment has been removed by the author.
Unknown said...

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

Huongkvb said...

Mua vé tại đại lý vé máy bay Aivivu, tham khảo

vé máy bay đi Mỹ tháng nào rẻ nhất

các chuyến bay từ mỹ về việt nam hiện này

các đường bay từ canada về việt nam

chuyến bay nhân đạo từ nhật về việt nam

vé máy bay từ hàn về Việt Nam

Vé máy bay từ Đài Loan về VN

khách sạn cách ly đà nẵng

chuyen bay chuyen gia trung quoc

Post a Comment

Ads