How to transfer Data from Multiple Excel sheets to single Database Table?

[Sekhar C]

I have 100 excel sheets with same field name,with same number of fields,with similar datatype. i want to transfer data from all excel sheets to one Sql database Table using one Package, i am using SQl Server Integration Services 2008 r2 version, Bussiness Intelligence Development Studio and MS SQL Server 2008.

please guide me.

[ck9663]

I have not used SSIS extensively, but I think you can make it in such a way that the input name is dynamic/variable. I always use T-SQL. Here, start from here

Good Luck!!!

~~ CK