Import multiple Excel files into SQL Server 2008 R2 using SSIS Packages?

Question

I have to insert data into two tables from two different excel sheets using SSIS packges. So, please some one tell me How to import multiple Excel files into SQL Server 2008 R2 using SSIS Packages?

Accepted Answer

since you have only 2 excel files and only two tables I don't see why use a foreach loop. Just follow this link and do it directly

If you need to insert from both excel files to both databases you can use a multicast component to create a copy of a dataset

Import multiple Excel files into SQL Server 2008 R2 using SSIS Packages?

Solution

Problem