SSIS: How do I create tables using Foreach Loop Container?
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