New Horizons Computer Learning Center
410-597-9722

6235A: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

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:
Exposure to enterprise data import and export scenarios
Experience navigating the Microsoft Windows Server environment
Experience with Microsoft SQL Server, including:

• SQL Server Agent
• SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
• SQL Server System tables
• SQL Server accounts (users and permissions)

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 2008 Integration Services

• Overview of SQL Server Integration Services
• Using Integration Services Tools
• Lab: Introduction to SQL Server Integration Services
• Lab Exercise 1: Using the Import and Export Wizard
• Lab 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: Developing Integration Services Solutions
• Lab Exercise 1: Creating an Integration Services Project
• Lab Exercise 2: Implementing a Package
• Lab Exercise 3: Building and Running an Integration Services package

Lesson 3: Implementing Control Flow

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

Lesson 4: Implementing Data Flow

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

Lesson 5: Implementing Logging

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

Lesson 6: Debugging and Error Handling

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

Lesson 7: Implementing Checkpoints and Transactions

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

Lesson 8: Configuring and Deploying Packages

• Package Configurations
• Deploying Packages
• Lab: Configuring and Deploying Packages
• Lab Exercise 1: Creating a Package Configuration
• Lab Exercise 2: Preparing a Package for Deployment
• Lab Exercise 3: Deploying a Package

Lesson 9: Managing and Securing Packages

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

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