Finding SSRS, SSIS dependencies given a table name

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  September 6, 2012 at 8:54 am

  #267360

  Guys

  Given a database table name, for eg, employee, we would like to know all the dependencies which include SSIS packages and SSRS Reports. For eg, we would like to get all the reports which use employee table and all the SSIS

  packages which use this employee table

  We can get view, function and SP dependencies DMV objects. Also tried exploring tools like pragmatic, apexsql and redgate - but did not provide options, though pragmatic used top down approach meaning given an SSRS report it will give you the dependencies but not the other way round.

  Any suggestions inputs would be helpful

  Thanks

• Chrissy321

  SSCoach

  Points: 15785

  More actions

  September 6, 2012 at 9:44 am

  #1534584

  This should get you started as far as SSIS.

  http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/70011/