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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.