title: How to Query Integration Services Catalog
body: <p>Problem: Identify all SSIS packages that connect to a specific database table on SQL Server. </p>
  
  <p>Details: There are almost 100 packages deployed to the server, most packages are huge in size, so it will be difficult to go through them manually with a high degree of accuracy.</p>
  
  <p>Is there a fast and automated way to do this?</p>
  
  <p>Potential solution using SQL Server: </p>
  
  <ol>
  <li>Query the Integration Services Catalog and retrieve the *.dtsx package</li>
  <li>Load the package data into an XML column/data type</li>
  <li>Parse/query the package for any reference to the specific database table</li>
  </ol>
  
  <p>Perhaps a C# application may do the same?</p>
  
  <p>I greatly appreciate any assistance that can be afforded.</p>