Click here to Skip to main content
15,886,963 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Comments
PIEBALDconsult 16-Jun-14 13:57pm    
Don't you need to use a Data Flow to fill the object-type variable? (I've only had to do that once so far.)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900