SQL Server Integration Services 2012 Design Patterns

9th September 2013 - 12th September 2013

Who is it for?

The target audience for this course is intermediate SQL Server Integration Services developers (or quick learners) who wish to learn best practices and design patterns, and those who wish upgrade their existing SSIS skills to 2012.

What you will learn

Introduction

Training overview, expectations, and introductions.

Metadata Collection

Using SSIS as an enterprise metadata collector. Automate the execution and collection of SQL Server performance metrics in the enterprise.

SSIS 2012 Catalog Execution

A look “under the hood” of the SSIS 2012 Catalog and SSISDB database. Learn where the SSIS Catalog metadata resides in SSISDB, see examples of custom reporting, and examine ways to extend functionality with custom objects.

Scripting in SSIS

Leveraging the Script Task to perform operations inside SSIS.
Using the Script Task and .Net to interface with external operations.

Designing Custom Tasks

Take SSIS scripting to the next level by building custom SSIS tasks in .Net.

Advanced Parameter and Variable Management

Using the new Project and Package Parameters.
Plumb the depths of the SSIS Expression Language.

SSIS Connections and Configurations Management

Using Environments in the SSIS 2012 Catalog.
Custom Connections Management.

Data Cleansing

Using the new Data Cleansing Transform.

Advanced Loop Containers

Typical (and atypical) uses of For Loop and Foreach Loop Containers.

Enterprise Data Integration Lifecycle Management

SSIS Project and Package Deployment Models.
Security, Deployment, Execution, Monitoring, and Maintenance.

Advanced SSIS Messaging

Impact of Deployment Model on project and package messaging.
Events and Event Handlers.
Logging, Reports, Configurations, and Environments.

ETL Design Patterns

Execution Patterns.
Custom Logging Patterns.

ETL Instrumentation Patterns.

Data Warehouse ETL Patterns
Dimension Loads.
Fact Loads.
Incremental Loads.
Change Detection methods.
Lookup Patterns.

Data Integration Automation

Package Generation in .Net.
Business Intelligence Markup Language (Biml).

Key benefits

At the conclusion of the training, attendees will have been exposed to:

New features in SSIS 2012
Advanced patterns for loading data warehouses
Error handling
The Project Deployment Model
Scripting in SSIS
Designing Custom Tasks
Managing, monitoring, and administering SSIS in the enterprise

Cost: £Ł999 + VAT up to March 31st 2013, Ł1099 + VAT after that +VAT

Trainer

Andy Leonard is a consultant, trainer and author with decades of ETL experience and years of SQL Server Integration Services experience. He regularly provides advice and free instruction at his blog at SQLBlog.com and on Twitter (@AndyLeonard).

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee. No refunds will be given to registrants who cancel less than 1 week before the beginning of the course or who fail to attend. Substitutions for paid registrants may be made at any time. However, written notice is required and for complete accuracy must include all pertinent changes for the substituting attendee.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.

Calvin Ferns

Consultant, Adatis

Chris has an incredible ability to explain even the most complex logic of Analysis Services and MDX in an easy and funny way. He is one of the best Microsoft Business Intelligence trainers I've ever met.