• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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