How to load multiple sheets of an Excel File in SSIS

Problem My client sends data inĀ an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS. Solution Source Files For demonstration purpose, I have an … Continue reading How to load multiple sheets of an Excel File in SSIS