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