Search for Variable Usage In SSIS tasks

Question

Hi all:

As what seems to be some sort of penance for sins in a prior life, I have been tasked with maintaining some SSIS packages. (NO! NO BADMOUTHING SSIS!! BAD PROGRAMMMER! NO DOUGHNUT!). Anyhoo, I many of the packages have variables, defined in an outer container, which are used in multiple inner containers, in script tasks. What I want to do, is find out all the places in a package a variable being used; in other words, search for instances of variable usage in all tasks of a package. This would be a huge help, but I cannot for the life of me find out how this can be done in BIDS. (this is SSIS/BIDS 2008) Thanks for any help,

YS

Answer 1

If I am correct the SSIS packages are xml files.

So one way I can think of is to could open the file with your XML-editor of choice and just to a simple search/find on the variable name.

Hope that helps!

Answer 2

There are tools out there that try to do that, not sure how good they are.