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.

Microsoft SQL Server 2005(c) Changing the Paradigm
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
ISBN: 0672327783
EAN: 2147483647
Year: 2005
Pages: 150 © 2008-2017.
If you may any questions please contact us: