O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Extracting and loading Excel data

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:

Getting ready

To get ready for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required