Detail

MSSQL Server 2005: Implementing and Maintaining SQL Server 2005 Integration Services Module 1: Introduction to SQL Server 2005 Integration Services * This module introduces the role that Integration Services plays in extracting, transforming, and loading data. This module also describes the tools that you can use to build and manage Integration Services solutions. Overview of Integration Services Solutions * Integration Services Tools Module 2: Developing Integration Services Solutions * This module provides an overview of the development tasks that are involved in creating an Integration Services package. After completing this module, you will be able to create a basic package. Creating an Integration Services Solution * Using Variables * Building and Running a Solution Module 3: Implementing Control Flow * This module introduces the tasks and precedence constraints that you can use to implement control flow in an Integration Services package. Control Flow Tasks * Control Flow Precedence Constraints * Control Flow Containers Module 4: Implementing Data Flow * This module describes the data flow sources, transformations, and destinations that you can use to implement a data flow task in an Integration Services control flow. It also explains how to use data flow paths to direct valid and invalid rows through the data flow. Data Flow Sources and Destinations * Data Flow Transformations * Data Flow Paths Module 5: Implementin