Can I access the values from the dataset that has been passed to For each loop container outside for each loop container in SSIS 2012
Posted on 2016-11-01
I have a select statement that gets a list of columns from a table and this dataset is passed to a for each loop container and the each column is assigned to a variable created at the package level.
The question is, can the value of these variables be accessed outside the for each loop container. If so, what values do they hold? Is it the most recent value?
If my for each loop container fails, I should update a column in a table based on the value of a column that has been passed and is being accessed in a for each container.
Any code/logic/examples are greatly appreciated!
Thanks a million in advance.