Recently we are planning to do some schema level changes to few tables, so now i have to find out all the depended scripts/SSRS reports/SSIS packages which are using those columns.
we have around 60 reports and around 20+ T-SQL scripts.
As its regular task as part of dev cycle, my manager asked me to create report with all Object References to packages/SSRS
To be more clear the Object references report will have below fields
BI Type Name TableNames ColumnNames
SSRS Report1 SimpleTable1 Col1,Col2,COl3
SSRS Report1 SimpleTable2 COl4,Col5,COl7
SSIS Package1 Table5 Col6,Col1
Please let me know if there is any automated way to find reference fileds.
I know there is way to find out related tables in a Stored procedure but is there any way i can find column names also ?