In SQL Server, how do I generate a list of DTS packages with a particular text pattern in them?

hpsuser
hpsuser used Ask the Experts™
on
Hello,

I am trying to generate a list of DTS packages with a particular text pattern "NXPRD" in them, in either the SQL tasks or the servers objects referenced.

Is there a way to do this without manually going into each DTS package and searching?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
hi Alisyed,


Thanks for responding, have tried without success to apply that solution, though I have no experience in ActiveX scripting so that is probably making it alot harder to implement...am still trying it though...
Commented:
Hello,

I was able to do query the DTS package names using the following query:
-------------------------------
select
a.*
from
MSDB.dbo.sysdtspackages a
join
(select name,MAX(createdate) maxCreateDate from MSDB.dbo.sysdtspackages group by name) b
on a.name = b.name and a.createDate = b.maxCreateDate
-------------------------------

Author

Commented:
SQL query allowed me to search for specific DTS package names

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial