I'm trying to loop through a result set to change the ConnectionString on my DataSource, as described here:http://www.codeproject.com/KB/database/foreachadossis.aspx
First I run a Script Task to populate an Object variable with my ADO recordset, then I use the ForEach ADO Enumerator on that variable. Within my ForEach loop container I have placed a script task with two MsgBoxs for debugging:
The first Message box returns each connection string from my table of data (as I intended), but the second shows me whatever value my ConnectionString variable was initially set to. I have added an expression for ConnectionString against my data source
(galaxy), and am led to beleive it is correctly mapped because the initial value of the variable is what gets returned by my message box.
What else am I missing here?
View Complete Post