Querying for Database in Connection Information...
I am currently going through a SQL Server consolidation project and have
numerous DTS packages across numerous servers that need to identified and
migrated over to SQL Server 2005.
Presently, I am manually going through each DTS package and going into the
SQL Server data source to find which database the source is pointing to.
Now, how for the love of cheese can I programmatically go through each DTS
package for a given server looking for a specific reference to a database
name in the connection information and return back to me the name of the DTS
package that has this reference?