Course Description | Outline | SQL Server Training | IT Training

Module 1: Introduction to SQL Server 2008 Integration Services

* Overview of SQL Server Integration Services
* Using Integration Services Tools

Lab : Introduction to SQL Server Integration Services

* (Level 200) Using the Import and Export Wizard
* (Level 200) Running an Integration Services Package

Module 2: Developing Integration Services Solutions

* Creating an Integration Services Solution
* Using Variables
* Building and Running a Solution

Lab : Developing Integration Services Solutions

* (Level 200) Creating an Integration Services Project
* (Level 200) Implementing a Package
* (Level 200) Building and Running an Integration Services package

Module 3: Implementing Control Flow

* Control Flow Tasks
* Control Flow Precedent Constraints
* Control Flow Containers

Lab : Implementing Control Flow

* (Level 200) Creating a Simple Control Flow
* (Level 200) Configuring Precedence Constraints
* (Level 200) Using Containers

Module 4: Implementing Data Flow

* Data Flow Sources and Destinations
* Basic Data Flow Transformations
* Advanced Data Flow Transformations
* Data Flow Paths

Lab : Implementing Data Flow

* (Level 200) Transferring Data
* (Level 200) Implementing Transformations
* (Level 200) Using Data Viewers
* (Level 200) Configuring Error Output

Module 5: Implementing Logging

* Overview of Integration Services Logging
* Enabling and Configuring Logging

Lab : Implementing Logging

* (Level 200) Configuring Logging
* (Level 200) Implementing Custom Logging

Module 6: Debugging and Error Handling

* Debugging a Package
* Implementing Error Handling

Lab : Debugging and Error Handling

* (Level 300) Debugging a Package
* (Level 300) Implementing Error Handling
* (Level 300) Controlling Failure Behavior

Module 7: Implementing Checkpoints and Transactions

* Implementing Checkpoints
* Implementing Transactions

Lab : Implementing Checkpoints and Transactions

* (Level 200) Implementing Checkpoints in a Package
* (Level 300) Implementing Transactions in a Package
* (Level 300) Implementing a Native Transaction

Module 8: Configuring and Deploying Packages

* Package Configurations
* Deploying Packages

Lab : Configuring and Deploying Packages

* (Level 200) Creating a Package Configuration
* (Level 200) Preparing a Package for Deployment
* (Level 200) Deploying a Package

Module 9: Managing and Securing Packages

* Managing Packages
* Securing Packages

Lab : Managing and Securing Packages

* (Level 200) Importing a Package
* (Level 200) Configuring and Monitoring a Package
* (Level 200) Scheduling a Package
* (Level 200) Securing a Package