How This Book Is Structured


To convey how to apply SSIS to various tasks, we’ve structure this book logically first to give you all the background and foundation information on scripting and data extraction, and then the details of data warehousing ETL, error handling, administration, and data integration, respectively. Given the popularity of DTS, a chapter has also been included on migrating to SSIS, and another chapter on scaling SSIS. Following is a brief description of how this book is structured:

  • Chapter 1 starts off the book with an introduction to the value proposition that SSIS brings to ETL and integration, and it also includes a refresher walk-through of the SSIS basics.

  • Chapter 2 focuses on advanced scripting. This chapter is placed up front because understanding when scripting should be used and how to implement scripting will be important in your architecture decisions. Several scenarios are presented that show powerful uses of scripting for more advanced requirements that cannot be designed easily with other out-of-the-box components.

  • Chapter 3 focuses on data extraction and lineage, a central aspect of ETL (the E in ETL). This chapter focuses on designing extractions, including incremental extractions, and tracking data from the source to the destination.

  • Chapters 4, 5, and 6 are dedicated to data warehousing ETL, primarily because a large portion of new data warehouse efforts are leveraging SSIS for the ETL process, and many existing ETL solutions are being rewritten in SSIS. Chapters 4 and 5 focus on the relational database transformation and loading methods for dimension and fact tables. Chapter 6 is dedicated to the SQL Server 2005 Analysis Services support within SSIS.

  • Chapter 7 focuses on error and event handling, as well as restartability, which overall will provide you with the capability to design solutions that gracefully can deal with processing errors and ease the execution through restartability.

  • Chapters 8 and 9 address the best practices for moving between your support and production environments. These chapters also address approaches to management of this process, as well as your package configurations and executions.

  • Chapter 10 focuses on heterogeneous integration. Chances are you will be pulling from or pushing to non-SQL Server systems or files (such as Oracle, DB2, Sybase, Teradata, and non-ANSI code page files, to name a few). This chapter focuses on what’s involved when interacting with these systems.

  • Chapter 11 addresses how to leverage SSIS features that make your migrated packages better. Some of you are involved in migrating DTS-based ETL to SSIS. Because of the architectural differences in the products, your migration will involve some attention. Chapter 11 goes beyond just getting your packages working in SSIS.

  • Chapter 12 discusses how to best take advantage of memory, when a relational engine should be used, where SSIS packages should be executed, and what the optimal loading techniques are for your destinations.



Expert SQL Server 2005 Integration Services
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
ISBN: 0470134119
EAN: 2147483647
Year: 2004
Pages: 111

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net