Search Task Properties in a DTS Package

[philhege]

Hi Folks,

Is there any programmatic method to search through the task properties of SQL DTS packages? I need to find a string in an Execute Process task, and don't feel like opening eleventy-leven packages to find it.

Any ideas? TIA for your time and expertise.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[mrdenny]

The packages are stored in binary format so you really can't search them.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com