Hello, I have a bunch of SSIS packages which refer a number of tables and stored procedures (mostly in control flow, SQL task). And I am in the process of deprecating tables/stored procedures which are not used by the applications I have. All I have is a bunch of C# applications and these SSIS packages. Finding the names of tables/stored procedures in those C# applications is easy. I don't know how to find out which all tables and stored procedures do these SSIS packages use. Is there a simple way of finding it out? I don't want to open each and every SSIS application and go through all the tasks in them to find out. Thanks in advance.

Since any SSIS package is just an XML file use a text editor at the very least (if you have access to the excellent Altova tools then you are more lucky). Also you can pump this XML into a table fields and do all sorts of Xpath/XQuery statements against it to make your search more easy.Arthur My Blog

Please check this http://stackoverflow.com/questions/3084829/tracking-sql-dependencies-within-stored-procs-ssis-ssrs http://uk.linkedin.com/in/ramjaddu