e-academy – IT training excellence in Cardiff, Newport, Bristol and South Wales

Course details
Fee £1,145
Days 3
Code 6235
Course dates
Feb 
Mar12
Apr 
May 
Jun 
Jul 

Click on a course date to book
e-mail us
or call us on
0845 650 6500

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

The Implementing and Maintaining Microsoft SQL Server 2008 Integration Services training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South WalesMicrosoft Certified Gold Partner for Learning Solutions

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.

Examination information

  • Exam: 070-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

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)

Course outline

Module 1: Introduction to SQL Server 2008 Integration Services

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

Module 2: Developing Integration Services Solutions

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

Module 3: Implementing Control Flow

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

Module 4: Implementing Data Flow

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

Module 5: Implementing Logging

  • Overview of Integration Services Logging
  • Using Logging

Module 6: Debugging and Error Handling

  • Debugging a Package
  • Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions

  • Implementing Checkpoints
  • Implementing Transactions

Module 8: Configuring and Deploying Packages

  • Package Configurations
  • Preparing and Deploying Packages

Module 9: Managing and Securing Packages

  • Managing Packages
  • Securing Packages