O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

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 ...

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