In this recipe, the use of Excel components to extract and load Excel data is demonstrated. As referred in the previous recipes, for security reasons, systems prefer to work with flat files, but people prefer work in Excel. Even if they have an application to use, they always end up exporting data to Excel. For that reason, there are hundreds of Excel files spread in all organizations. Even though with poor data quality initiatives, these files have important data to integrate and to be analyzed by end users, mainly decision makers. For that reason, the Excel Source and Destination components are often used in SSIS projects.
An Excel sample file is shown in the following screenshot:
