Hi Keith
One of my packages also process some tasks on a list of tables, it works fine.
I have declared 3 variables:
TblList as object
TblId as Int16
TblName as string
Query statement select row_number() over (order by object_id asc) as id,name from sys.tables where type = 'U'
from SQL task stores result set in TbLList variable.
Foreach Loop Container do iteration on Foreach ADO Enumerator (User::TblList) and maps values to User::TblId And User::TblName,
then inner For Loop starts and do some jobs with table, when finish returs to extrenal (Foreach Loop).
Br.
Mike