New Horizons Computer Learning Center
410-597-9722

2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services (SSIS)

Course Length: 3 Days

Overview:
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Prerequisites:
Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Course 2779: Implementing a Microsoft SQL Server 2005 Database
Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Course Objectives:
Upon successful completion of this course, students will be able to:

• Describe SQL Server Integration Services and its tools
• Create an Integration Services package
• Implement control flow in an Integration Services package
• Implement data flow in an Integration Services package
• Implement logging in an Integration Services package
• Debug and implement error handling in an Integration Services package
• Implement checkpoints and transactions in an Integration Services package
• Deploy an Integration Services package
• Manage and secure an Integration Services package

Course Content

Lesson 1: Introduction to SQL Server 2005 Integration Services

• Overview of Integration Services Solutions
• Integration Services Tools
• Lab 1: Using SQL Server Integration Services
• Exercise 1: Using the Import and Export Wizard
• Exercise 2: Running an Integration Services Package

Lesson 2: Developing Integration Services Solutions

• Creating an Integration Services Solution
• Using Variables
• Building and Running a Solution
• Lab 2: Implementing an Integration Services Solution
• Exercise 1: Creating an Integration Services Project
• Exercise 2: Implementing a Package
• Exercise 3: Building and Running an Integration Services Project

Lesson 3: Implementing Control Flow

• Control Flow Tasks
• Control Flow Precedence Constraints
• Control Flow Containers
• Lab 3: Implementing Control Flow
• Exercise 1: Creating a Simple Control Flow
• Exercise 2: Configuring Precedence Constraints
• Exercise 3: Using Containers

Lesson 4: Implementing Data Flow

• Data Flow Sources and Destinations
• Data Flow Transformations
• Data Flow Paths
• Lab 4: Implementing Data Flows
• Exercise 1: Transferring Data
• Exercise 2: Implementing Transformations
• Exercise 3: Using Data Viewers
• Exercise 4: Configuring Error Output

Lesson 5: Implementing Logging

• Overview of Integration Services Logging
• Implementing Logging
• Lab 5: Implementing Logging
• Exercise 1: Configuring Logging
• Exercise 2: Implementing Custom Logging

Lesson 6: Debugging and Error Handling

• Debugging a Package
• Implementing Error Handling
• Lab 6: Debugging and Error Handling
• Exercise 1: Debugging a Package
• Exercise 2: Implementing Error Handling
• Exercise 3: Controlling Failure Behavior

Lesson 7: Implementing Checkpoints and Transactions

• Implementing Checkpoints
• Implementing Transactions
• Lab 7: Implementing Checkpoints and Transactions
• Exercise 1: Implementing Checkpoints in a Package
• Exercise 2: Implementing Transactions in a Package
• Exercise 3: Implementing a Native Transaction

Lesson 8: Deploying Packages

• Package Configurations
• Deploying Packages
• Lab 8: Deploying Integration Services Packages
• Exercise 1: Creating a Package Configuration
• Exercise 2: Preparing a Package for Deployment
• Exercise 3: Deploying a Package

Lesson 9: Managing and Securing Packages

• Managing Packages
• Securing Packages
• Lab 9: Managing and Securing Packages
• Exercise 1: Importing a Package
• Exercise 2: Configuring and Executing a Package
• Exercise 3: Scheduling a Package
• Exercise 4: Securing a Package

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com