search DTS for stored proc name

#1

I want to search all DTS in my server for a specific sp name. Is there any
query or searching way by which i can do this without opening each and every
DTS

#2

Hello Vikram,

You will have to do this using the object model and technically open every
single package.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

I want to search all DTS in my server for a specific sp name. Is there
any query or searching way by which i can do this without opening each
and every DTS

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

search DTS for stored proc name

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

search DTS for stored proc name - 04-10-2006 , 04:46 AM

Re: search DTS for stored proc name - 04-10-2006 , 05:45 AM