Vikash Kumar Singh (7/5/2013)
You can try the solution listed here.SSIS: How to load multiple excel files into multiple SQL tables?
Although it looks like this will work, SSIS is not really adding anything here - might as well keep the whole thing in T-SQL if following this route.