You can use a ForEach Loop task to read from a recordset object and assign the column values from each row to a variable.