Chapter 14. Architectural Components of Microsoft SQL Server 2008 Integration Services

In Part II, we looked at the ways in which Microsoft SQL Server 2008 Analysis Services (SSAS) delivers a set of core functionality to enable analysis of data warehouse data within a business intelligence (BI) solution. But how does the data get from the disparate source systems into the data warehouse? The answer is Microsoft SQL Server 2008 Integration Services (SSIS). As the primary extract, transform, and load (ETL) tool in the SQL Server toolset, Integration Services provides the core functionality required to extract data from various source systems that contain the information for a BI solution, transform the data into forms required for analysis, and ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.