there are a lot of FOREACH Loop for SSIS :

This one will give you a head start.

http://www.select-sql.com/mssql/loop-through-ado-recordset-in-ssis.html

hope it helps.