[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

investigate ssis variable

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.

Thanks,

Deep
0
patd1
Asked:
patd1
3 Solutions
 
lcohanDatabase AnalystCommented:
If you Export the SSIS package as a DTSX file you can open that file and do a text search on that variable name as the DTSX is just an XML file.
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
In a perfect world, the variable should has a scope which represents which task it belongs to, check if that's your case and you'll be lucky then.. :) var
0
 
Alpesh PatelAssistant ConsultantCommented:
Yes,

Just open your package in BIDS and right click on package and go to code. It will open up a XML file. in that you can search the variable name.
0
 
patd1Author Commented:
Great! Thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now