x

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,

AKT

more ▼

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

AKT gravatar image

AKT
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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x939
x27

asked: Apr 13, 2010 at 07:36 AM

Seen: 1977 times

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