Summary

SQL Server replaces DTS by introducing a revolutionary, completely redesigned ETL and integration platform, called SSIS. This platform facilitates the first step in the business intelligence life cycle: integrating, cleansing, transforming, validating, and aggregating data from various sources.

This chapter introduces you to SSIS concepts by discussing enhancements introduced in SSIS, SSIS architecture, and the SSIS toolset. BIDS and other command-line utilities are discussed, as is the step-by-step process to design, execute, and log SSIS packages. The final sections in the chapter talk about SSIS wizards, migration issues, and SSIS's role in data warehousing.

Chapter 13, "What's New in SQL Server Analysis Services 2005," focuses on the second step in business intelligence solution developmentanalysisand discusses Analysis Services 2005 in great detail.