Thursday, October 11, 2012

Loop over an array of data in a table & perform a set of tasks for each row

Loop over an array of data in a table & perform a set of tasks for each row
 Tasks Required: Execute SQL Task, Foreach Loop

Solution: Use an Execute SQL Task to load the array and send the data into an object variable. Loop over the variable in a Foreach Loop by use an ADO Enumerator.

No comments:

Post a Comment