Database Courses:
Implementing & Maintaining Microsoft SQL Server 2005 Integration Services Training Course

Classroom Courses ~ Closed Courses ~ Onsite Courses ~ Training Passport ~ MCSE Courses ~ CBT Courses
Home Page ~ Contact ~ Training Centre ~ Course Schedule ~ Late Availability ~ Consultancy

PTR Associates Ltd - Classroom Based Courses, Wokingham, Berkshire, uk

21a Peach Street, Wokingham, Berkshire, UK
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk Web: www.ptr.co.uk

Implementing & Maintaining Microsoft SQL Server 2005 Integration Services Course

Course Description

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. It 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 2005 Integration Services.

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.

Course pre-requisites:

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

scheduled dates / price

Topics covered on the 3 day Implementing & Maintaining Microsoft SQL Server 2005 Integration Services course

Introduction to SQL Server 2005 Integration Services

Overview of Integration Services Solutions
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 Precedence Constraints
Control Flow Containers

Implementing Data Flow

Data Flow Sources and Destinations
Data Flow Transformations
Data Flow Paths

Implementing Logging

Overview of Integration Services Logging
Implementing Logging

Debugging and Error Handling

Debugging a Package
Implementing Error Handling

Implementing Checkpoints and Transactions

Implementing Checkpoints
Implementing Transactions

Deploying Packages

Package Configurations
Deploying Packages

Managing and Securing Packages

Managing Packages
Securing Packages

This is an instructor led training course taught in a classroom based environment.

Course Classification: Technical Training Course

Course Fee = £1005

(excl.VAT)

Scheduled course dates

May 2008	June 2008	July 2008	August 2008	September 2008
12-14	9-11	7-9	4-6	8-10

Print / Download PDF Version of full course schedule

If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2005 Training and bespoke SQL Server 2005 courses

If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.

The Implementing & Maintaining Microsoft SQL Server 2005 Integration Services course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.

View SAVE IT Scheme Details