John Mitchell-245523 (3/6/2014)
You're making things too complicated. Your result set contains only one row, so change the result set to No Result Set and use output parameters in the Parameter Mapping page instead. Then you can use the variables in your next Execute SQL task without the need for a For Each Loop container.John
Hi John. I am not sure what you mean by result set contains only one row. The query resuls returned by the 1st Execute SQL Task may return 1 to 100 items with commas added to be used in the IN statement for the 2nd Execute (update) SQL Task. I figured the Foreach would be used to concatenate the result set and save it as a string in the variable.