6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

This course provides material for:
Microsoft Exam code: Exam 70-448

Overview

This 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.

Objectives

After completing 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

Audience

This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

Syllabus

Introduction to SQL Server 2008 Integration Services

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

: Developing Integration Services Solutions

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

Implementing Control Flow

  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers

Implementing Data Flow

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

Implementing Logging

  • Overview of Integration Services Logging
  • Using Logging

Debugging and Error Handling

  • Debugging a Package
  • Implementing Error Handling

Implementing Checkpoints and Transactions

  • Implementing Checkpoints
  • Implementing Transactions

Configuring and Deploying Packages

  • Package Configurations
  • Preparing and Deploying Packages

Managing and Securing Packages

  • Managing Packages
  • Securing Packages

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Online - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

SQL Server Integration Services
Worldwide
This skill has an average salary of
US$77,417
and is mentioned in
0.39%
of job ads.
Microsoft SQL Server
Worldwide
This skill has an average salary of
US$80,923
and is mentioned in
1.97%
of job ads.
Debugging
Worldwide
This skill has an average salary of
US$88,542
and is mentioned in
1.04%
of job ads.