Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2012-09-06 : 10:56:34
|
| GuysGiven 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 SSISpackages 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 helpfulThanks |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-09-06 : 13:23:56
|
| I don't know of any good way to do that. You can, of course, search the files for keywords. But, that doens't always help. I heard that Microsoft has a project code named Barcelona that will crawl "things" (Databases, ETLs, reports, etc.) and allow you to trace a column through all those layers. Unfortunately, I have not seen it in person, so I don't know if you can get ahold of it yet or not. However, I did see it demoed and it looked promising. |
 |
|
|
|
|
|
|
|
Finding SSIS, SSRS dependencies given a table name