Chapter 1: Introduction to SQL Server Integration Services
After completing this chapter, you will be able to:
- Understand the purpose of SSIS with data integration applications.
- Understand SSIS objects used to create SSIS applications.
- Understand SSIS performance processing architecture.
- Understand SSIS development, administration, and run-time components.
Microsoft SQL Server 2005 Integration Services (SSIS) is the toolset used to help you implement data integration process applications among your business application system’s files and databases. SSIS is much more than a simple extract, transform, and load (ETL) process. SSIS enables database administrators and application developers to design, implement, and manage complex, high-performance ETL applications. Using SSIS, you can select data from one or more sources and standardize, join, merge, cleanse, augment, derive, calculate, and perform just about any other function and operation required for your data integration applications. SSIS also provides procedures to automate many of the administrative functions for SQL Server databases, tables, On-Line Analytical Processing (OLAP) Cubes, and many other functions for components of SQL Server 2005.
The ETL phase of data warehousing, data migration, application integration, and business intelligence projects are commonly from 60 percent to as much as 80 percent of the work effort. Effective deployment of technology such as SQL Server 2005 Integration Services can significantly reduce the time, effort, and cost for this phase. This book is designed to show you how to use the features of SSIS and how best to implement these SSIS features and capabilities with data integration projects for your own application systems environments. Through a series of step-by-step demonstrations and exercises, you will work with common, practical, real-world examples to build SSIS applications. These exercises will show how to work with relational and non-relational data sources, manage referential integrity, handle slowly changing dimensions and other data warehousing and business intelligence challenges, and implement complex transformations. You will also learn how to use the debugging and error-handling features in SSIS to detect, troubleshoot, and recover from errors that might occur during data integration process execution. This book will also show you how to manage SSIS applications as well as provide you with best practices and disciplines for building and maintaining SSIS applications within your business application systems environments.
© Microsoft. All Rights Reserved.