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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.