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

Course Length
3.0 Days

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

Prerequisites
Before attending this course, students must have:

  • 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).

Learning Objectives

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

Exam Certification
This is part of a certification series 70-448 SQL Server 2008, Business Intelligence Development Certification which includes courses 6234, 6235, and 6236.

Course Content


MODULE 1 - INTRODUCTION TO SQL SERVER 2008 INTEGRATION SERVICES

1.Describe Integration Services solutions
2.Use Integration Services tools

MODULE 2 - DEVELOPING INTEGRATION SERVICES SOLUTIONS

1.Create a SQL Server Integration Services solution.
2.Use variables.
3.Build and run a solution.

MODULE 3 - IMPLEMENTING CONTROL FLOW

1.Configure control flow tasks.
2.Configure control flow precedence constraints.
3.Configure control flow containers.

MODULE 4 - IMPLEMENTING DATA FLOW

1.Implement data flow sources and destinations.
2.Implement basic data flow transformations.
3.Implement advanced data flow transformations.
4.Implement data flow paths.

MODULE 5 - IMPLEMENTING LOGGING

1.Describe Integration Services logging.
2.Implement Integration Services logging.

MODULE 6 - DEBUGGING AND ERROR HANDLING

1.Debug an SSIS package.
2.Implement error handling.

MODULE 7 - IMPLEMENTING CHECKPOINTS AND TRANSACTIONS

1.Implement checkpoints.
2.Implement transactions.

MODULE 8 - CONFIGURING AND DEPLOYING PACKAGES

1.Implement package configurations.
2.Deploy packages.

MODULE 9 - MANAGING AND SECURING PACKAGES

1.Manage packages.
2.Secure packages.