GOC61 - Mastering SSIS

This two-day instructor-led course provides students with the knowledge and skills to gain most of the Microsoft SQL Server 2005 Integration Services. This course is focused on advanced topics in SQL Server Integration Services as speed optimization, best practices, scripting, creating custom tasks and components.

Who the course is for

This course is intended for SQL Server Integration Services professional.

What we teach you

Optimize SSIS design

Handle complex transformations with Script objects

SSIS Object model

Create custom tasks and components

Master commonly & exotic used tasks and components

Measure SSIS performance

Required skills

Working knowledge of the SSIS

Basic knowledge of .NET languages (C#, VB .NET)

Teaching methods

Expert instruction with practical examples, computer practice

Teaching materials

Books published by specialist publishers.

Course syllabus

Review

SSIS Tasks
SSIS Components
SSIS Architecture

Object model

Control Flow
Data Flow

Scripts vs. custom code

Script Task & Custom Task
Script Component & Custom Component

Speed Optimization, Design, Tip & Tricks in:

Dimension ETL
Fact Table ETL
SSAS processing with SSIS (optional)
Deployment
Managing
Scaling
Upgrading (optional)

Recommended prior courses

MOC 2792 - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services

Catalog price of course and handbook

Locality Course price ex VAT Price of handbook ex VAT Number IT points

Praha 9900 Kč 1550 Kč 20 items

Brno 9900 Kč 1550 Kč 20 items

Course dates

Course date		Course length	Locality	Price ex VAT	Handbook ex VAT	Speaker language
20.01.2011		2	GOPAS Praha	9900 Kč	1550 Kč
13.01.2011		2	GOPAS Bratislava	330 EUR	61 EUR

If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).