I am trying to Execute a Foreach Loop after a Execute SQL statement. I have added an Execute SQL task on the control flow. I have created to project level variables, one with a data type of Object, Value = System.Object, and the other data type String, Value "".
I have configured the SQL task to Return a full result set, and conntected it to a Foreach Loop container on the Control Flow. I have added a Data Flow task inside the Foreach Loop container. When I edit the Foreach Loop container, the collection tab does not display the ADO Enumerator. I downloaded a sample from this web site: http://www.timmitchell.net/post/2013/05/28/using-the-ssis-object-variable-as-a-result-set-enumerator/
When I open that sample, I DO see the ADO collection. I have tried to set my package like this sample, but no matter what I do, the collection tab does not let me make any changes.
The Execute SQL has the following SQL statement:
SELECT distinct MoveID
FROM [dbo].[ccRateEstimates]
WHERE [Print_Flag] != 'Y'
Please let me know if more information would help get an answer.
ANY help would be GREATLY appreciated!
Thanks,
Sharon