Running Multiple SQL Query Files

I have several SQL files that make several different table updates and data changes.

How would I create something (maybe an SSIS package?) or even write a T-SQL script that runs through these files and executes the queries contained in them?

(I put this thread in SQL General also because I wasnt sure if this could be implemented in T-SQL or not.)

Right now what I have is a ForEachLoop Container with an ExecuteSQL task component inside of it. I'm thinking that the contents of each of the sql files would be copied over to a "Temp.sql" file and then executed in the loop. So I've created a Temp.sql file for this purpose and the properties of the ExecuteSQLTask component are setup as so:

(I've created my connection managers appropriately with an OLEDB source and a File Connection pointing to Temp.SQL)
ConnectionType OLEDB
Connection servertest
SQLSourceType File connection
FileConnection Temp.sql

And for my ForEachLoop container, my properties have been set as:
Collection
--> Enumerator Foreach File Enumerator

--- Enumerator Configurations ---
Folder: C:lahblahblah
Files: *.sql
with retrieve file name set as Fully Qualified

Have I set this up properly? (obviously not, because it's not working )