Following is the appropriate forum for your question:
SQL Server Integration Services
Article: Looping Through Excel Files And Sheets in SSIS
Kalman Toth SQL SERVER & BI TRAINING
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?