SSIS for/each loop to ETL tables across databases

I have 100 pre-written SQL Server table insert statements, to pull data from a Progress database via openquery into 100 SQL Server tables e.g. insert into table1 (col1 varchar(50), col2 varchar(10)) select X,Y from aprogresstable insert into table1 (col1 varchar(40), col2 int, col3 varchar(15)) select X,Y,Z from anotherprogresstable for 100 tables.. However, this is slow over openquery. Therefore, I'd like to import these data nightly from Progress into existing SQL Server tables using SSIS. What is the best way to achieve this, without needing to create 100 data flow components (e.g. 100 sources, 100 destinations). SQL Server Import/Export wizard is an option here but I've found it has data mapping issues with date fields. **Therefore, is it possible to create a For/Each loop to loop through 100 SQL insert statements via SSIS to pull data from Progress/Push to existing SQL Server Tables?** Thanks!