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.