SQLTeam.com | Weblogs | Forums

Find where connection manager is used in a package and/or project

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

Ssis is basically an xml file. Using powershell or python, you can and search everything in it