I am working on an ETL project which is based on an existing template based framework. Due to our customization of the framework we are not using many of the variables that come with the templates and we want to remove them.
I want to know, is there a quick way (or any tool) to find out (or get a list of) all unused variables (and possibly the unused columns) in a SSIS package (or if possible the project) without having to run them. Due to the time constraint & large number of packages, we can't afford to go through each package to find out unused variables manually.
I believe, one possible way could be reading the XML of package and count the occurrences of each variable but there can be complexities involved like same variables occurring in different scopes, parent package variables etc. which again requires deep analysis and time and I am sure someone would have already faced this before and can help me in this.
Any help in this regard would be a great help.
Thanks in advance,