Hi,

I usually do this almost everyday at my job place. I have to get the data from different excel files in one package. I use a very simple method. In the control flow, I drag and drop one dataflow and then I have 3 excel sources in a single data flow task. That means 3 excel connection managers also. And then, I use the data conversion transformation and finally the SQL Server destination. It works fine. I get the data from all three different excel files by executing a single package.

One important thing here. Make sure that in your destination, in the properties window, the tablock option is off. Tablock is on by default, so you need to turn it off or mention it as false in order to get the data from all three sheets.

Hope this works for you too.

Thanks.

notes4we