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.