Some ideas to help.

For Each Loop Container and through folder of sql scripts picking up the sql file name and using this as a variable. Use a Command Line task using SQLCMD command. Export the results to csv.

1. Pull over For Each Loop Container

2. Locate the folder location with the 30 sql scripts

3. Use this location in FEL (For Each Loop). Store FileName in Variable

4. Pull over Process Task and use sqlcmd using Variable as parameter to execute sql statement

sqlcmd -Sservername -d myDB -E -i D:\SQL\Script1.sql -o "MyData.csv"

See http://www.sqlservercentral.com/Forums/Topic799839-324-1.aspx#bm897838

You will need to make the output variable as well. Probably use filename in FEL.

This would output 30 csv files with data from sql scripts. I know you wanted excel but this could help guide you to your goals.

Another idea is to use RecordSet Destination which looks interesting as well.

http://consultingblogs.emc.com/jamiethomson/archive/2005/05/30/1489.aspx