title: Tracking SQL Dependencies within Stored procs / SSIS / SSRS
body: <p>We have an environment where we develop within T-SQL, SSIS and SSRS. We have core databases for our own systems, but we have dependencies to another SQL system that we directly extract data from by calling tables, views and stored procs (not ideal, but that is for another day).</p>
  
  <p>As a developer I want to make sure that at any point in time I can identify all of my dependencies on the secondary database. This will hopefully allow me to identify areas of concerns during upgrades and allow for better communication with the secondary team to ensure that any potential changes required to our systems are identified early.</p>
  
  <p>Is anyone aware of any tools / methods that will intelligently identify all DB objects used within:</p>
  
  <ul>
  <li>SSIS Packages</li>
  <li>SSRS Reports</li>
  <li>Calls to objects through a linked server in stored procs, etc</li>
  </ul>
  
  <p>My current alternative is to manually track all the objects we use - but I would MUCH prefer some way of automating this to eliminate human error in the process. We are currently moving towards a TFS environment for our source control, so any plug-ins for this would be a big bonus!</p>
  
  <p>Thanks</p>