I have a big and complex SSIS package that I need to modify. One of my execute sql task is passing the value of the variable User::strDocStatus as parameter to execute an sproc. I need to find out where the value of this variable is getting set. It is too time consuming to open each sql task and check the result set, and also open all script tasks to see if it is setting the value of this variable.
Please let me know if there is a more efficient way to know this.