Announcing SSIS Design Patterns Training in London 7-10 Sep 2015!

I am honored to work alongside TechniTrain to deliver SQL Server Integration Services Design Patterns in London 7-10 Sep 2015!

Register before 31 Mar to save £100.

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 or 2014.

Course Highlights

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.

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

• Business Intelligence Markup Language (Biml).

Key benefits

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

• New features in SSIS 2012/2014
• 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

I hope to see you in London!

:{>

Learn more:
Linchpin People Blog: SSIS
Stairway to Integration Services