Question: how to extract the data from multiple excel sheets in ssis?
Answer: Step 1 - Create an SSIS Package. ... 
Step 2 - Create SSIS Variables. ... 
Step 3 - Foreach Loop Container. ... 
Step 4 - Configure the Enumerator to "Foreach ADO.NET Schema Rowset Enumerator" ... 
Step 5 - Create a Collection in the Foreach Loop Editor.