SSIS: How do I create tables using Foreach Loop Container? I got a bunch of .sql files each containing a script that would create a certain table.

I want to create tables using these scripts in said files (each table to be created using one file).

I got a foreach loop container that specifies the path and which files to use.

I don't know how to configure the Execute SQL Task inside the foreach loop container to execute the script in each one of these files in order to create the tables.
Set the Foreach Loop as a Foreach File Enumerator pointed at your .sql files
Create a variable and map the Fully qualified file name to it
Set the Execute SQL Task's SQLSourceType to File connection, and create a new file connection for it
Set the Connection String expression on the file connection to your file name variable