I have an SSIS project with over 150 packages in it, and I want to see which ones use a specific connection manager in them. I could go through them all one by one and look manually but this is a bit tiresome.
What is the easiest way to search a package for the uses of said connection manager? Is it possible to search ALL packages at once for uses of the connection manager?
Many thanks
Martyn