FOREACH ADO Enumerator and SSIS
Posted on 2007-07-20
In SSIS, if I want to loop through a table, pulling out one column in that table based on certain criteria, how do I loop through each returned row? I beleive it is the FOREACH ADO enumerator, but I can't find a simple example on how to put one together. More importantly, how to build the dataset within the FOR EACH loop. If someone could point me to, or give me an example of how to set up a simple FOREACH loop that takes a query from a table, returns one column, and runs a query on each row return from that column, I would be grateful.