Iterate Through All Excel Files And All Their Sheets

hello,



i need to transfer (migrate ) the data from xl sheet to sqlserver but actually the thing is if the source excel file has different sheets, in each sheet i have the data



and i need to move the entire data( all the data that is present in all sheets of the excel file) to a single table into sql server



like wise i have many xl files ( which have many sheets ) .



for eg:



excel file 1:

-> sheet 1

-> sheet 2

-> sheet 3

excel file 2:

-> sheet 1

-> sheet 2

-> sheet 3

excel file 3:

-> sheet 1

-> sheet 2

-> sheet 3



now i need to get the data from all of the files and i need to insert into a single table ( sql server) in ssis package

so plz help me by giving the solution asap.



thanks



B L Rao