Meta Data Refresh While Looping Through Tables In Ssis

The situation: I have a list of queries written so that each select data from their respective table. I want to create this list of queries as an SSIS object variable and iterate

Solution 1:

No, if the meta data is not the same for all queries, then you cannot use them in a single data flow task. The meta data for a DFT is set at design time, and cannot change or "refresh" during a run. You're correct that delaying validation will not help with this.

You might want to look into BiML, which dynamically creates packages based on meta data.