Listing all unused variable in a SSIS package.

Hi All,

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,


more ▼

asked Apr 13, 2010 at 07:36 AM in Default

avatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 13, 2010 at 07:36 AM

Seen: 2428 times

Last Updated: Apr 13, 2010 at 08:41 AM

Copyright 2018 Redgate Software. Privacy Policy