Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

SSIS Foreach Loop Editor Variable Mapping- How can i edit the variable or see what it is asigned to ?

SSIS Foreach Loop Editor Variable Mapping- How can i edit the variable or see what it is asigned to ?
Variable-name.PNG
0
midwestexp
Asked:
midwestexp
  • 3
  • 3
1 Solution
 
HoggZillaCommented:
Here is my document on Variables in SSIS. You can create a Script Task and view the value in a popup Message Box. That is explained in this document. Let me know.
SSIS-Populate-Variable.pdf
0
 
HoggZillaCommented:
Why do you have 2 variables named ToFolder. You must have created one with a different scope. Go back to the variables window and remove or rename one.
variables.bmp
0
 
midwestexpAuthor Commented:
Hello Hogg , Thanks for your document . How can i get to this screen what you have attached , this is my question,

Thanks
MW
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
midwestexpAuthor Commented:
BTW i am using SSIS 2005 Version
MW
0
 
PedroCGDCommented:
you can see the value of the variable using SSIS debug, or you can create a script task to show the value in a msgbox, or inside a dataflow using data viewer.
I hope this help you!
Regards!
Pedro
0
 
HoggZillaCommented:
On the menu, SSIS, select Variables and this will open the Variables Window.
0
 
midwestexpAuthor Commented:
Yes this what i am asking for.
0

Featured Post

Technology Partners: 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!

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