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