Search for Variable Usage In SSIS tasks
- by yoni.s
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