Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Name

Author  Topic 

priyaram
Yak Posting Veteran

82 Posts

Posted - 2005-10-27 : 13:41:17
suppose if we want to know which DTS is called from which job,
is there a way that we can get the package name from the encrypted script that we used inside the job to call DTS.

How can we decript the script

thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-10-27 : 14:51:52
This is not possible if you used the DTS wizard to schedule the job. If however you created the job on your own via dtsrun.exe, then yes. It sounds like you used the DTS wizard though as it's encrypted.

Tara
Go to Top of Page
   

- Advertisement -