开发者

Search for Variable Usage In SSIS tasks

开发者 https://www.devze.com 2023-01-02 01:56 出处:网络
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!).

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 cont开发者_运维技巧ainer, 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


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!

0

精彩评论

暂无评论...
验证码 换一张
取 消