I don't think you can use a SQL Query task to get the table names.

I believe you will need to add a Data Flow, and in the data flow use an OLE DB source to query the table names from your database. You can then use a Recordset destination, which will allow you to specify an object variable to put the recordset into.

Once you've done that, you should then be able to set the ForEach loop up to loop through the records in the recordset stored in your object variable.