Implementing/Maintaining SQL Server 2008 Integration Services

Master the art of data manipulation and streamline your data flow processes by learning to implement robust ETL solutions with Microsoft SQL Server 2008 Integration Services, designed for IT professionals and developers.

Course Thumbnail

Essential Skills Gained

Checkmark

Design Integration Services packages.

Checkmark

Implement control flow and data flow in packages.

Checkmark

Deploy and manage Integration Services solutions.

Checkmark

Secure and log Integration Services package execution.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • IT professionals
  • Database developers
  • Data analysts
  • Business intelligence specialists

Description

Elements of this syllabus are subject to change. 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.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Introduction to SQL Server 2008 Integration Services

  1. Overview of SQL Server Integration Services

  2. Using Integration Services Tools

  3. (Lab) Using the Import and Export Wizard

  4. (Lab) Running an Integration Services Package

Module 2: Developing Integration Services Solutions

  1. Creating an Integration Services Solution

  2. Using Variables

  3. Building and Running a Solution

  4. (Lab) Creating an Integration Services Project

  5. (Lab) Implementing a Package

  6. (Lab) Building and Running an Integration Services package

Module 3: Implementing Control Flow

  1. Control Flow Tasks

  2. Control Flow Precedent Constraints

  3. Control Flow Containers

  4. (Lab) Creating a Simple Control Flow

  5. (Lab) Configuring Precedence Constraints

  6. (Lab) Using Containers

Module 4: Implementing Data Flow

  1. Data Flow Sources and Destinations

  2. Basic Data Flow Transformations

  3. Advanced Data Flow Transformations

  4. Data Flow Paths

  5. (Lab) Transferring Data

  6. (Lab) Implementing Transformations

  7. (Lab) Using Data Viewers

  8. (Lab) Configuring Error Output

Module 5: Implementing Logging

  1. Overview of Integration Services Logging

  2. Enabling and Configuring Logging

  3. (Lab) Configuring Logging

  4. (Lab) Implementing Custom Logging

Module 6: Debugging and Error Handling

  1. Debugging a Package

  2. Implementing Error Handling

  3. (Lab) Debugging a Package

  4. (Lab) Implementing Error Handling

  5. (Lab) Controlling Failure Behavior

Module 7: Implementing Checkpoints and Transactions

  1. Implementing Checkpoints

  2. Implementing Transactions

  3. (Lab) Implementing Checkpoints in a Package

  4. (Lab) Implementing Transactions in a Package

  5. (Lab) Implementing a Native Transaction

Module 8: Configuring and Deploying Packages

  1. Package Configurations

  2. Deploying Packages

  3. (Lab) Creating a Package Configuration

  4. (Lab) Preparing a Package for Deployment

  5. (Lab) Deploying a Package

Module 9: Managing and Securing Packages

  1. Managing Packages

  2. Securing Packages

  3. (Lab) Importing a Package

  4. (Lab) Configuring and Monitoring a Package

  5. (Lab) Scheduling a Package

  6. (Lab) Securing a Package

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.