Is there way to provide a query as the enumerator for a ForEach Loop? Or do I need to execute the query in a Script Task and store the results in an array or DataTable?Paulo Morgado

Create a variable of type "Object" Use the Execute SQL task to run the query - set the resultset property to "Full Result Set" and go to teh Result Set window in the gui. Set Result Name = 0 and Variable Name to your object variable Create a For Each Loop and set the collection type to Foreach ADO Enumerator and ADO Object Source Variable to your object variableRgds Geoff

Thanks. I had been fooled by the ADO Object Source Variable instead of ADO.NET Object Source Variable.Paulo Morgado