THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

Presenting at SQLBits 9!


2011 is turning into The Year of Pre-Cons!

SQLBits 9, Here I Come!

(Love this graphic!)

There are some awesome pre-conference sessions lined up for SQLBits 9 Training Day by presenters such as: Allen White, Maciej Pilecki, Matt Masson, Christian Bolton, Satya SK Jayanty, Marco Russo, Duncan Sutcliffe, Jeremy Kashel, and Martijn Evers. Plus me! I know – I can hardly believe it myself! As I type this, I’m working on a gig in Saskatchewan. I had to learn to speak Canadian for the trip (and have to keep telling restaurants to please not put gravy on my French fries!) – now it looks like I have to learn to speak English.


I’ll be presenting A Day of SSIS:

A Day of SSIS was developed by Andy Leonard to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions.

The training is focused around lectures and emphasizes a practical approach.

Target Audience

The target audience for this training is database professionals, application developers, and business intelligence practitioners interested in acquiring or expanding their existing SSIS skill set.


No experience with SQL Server or SQL Server Integration Services is required before attending this training.

It is helpful (but not required) that students possess some knowledge of and experience with relational databases. SQL Server knowledge / experience will be more helpful than experience and knowledge with other technologies.

Training Objectives

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

  • Using SSIS to develop data integration solutions.
  • Using SSIS to load a database table.
  • Troubleshooting real-world SSIS Data Flow Task errors.
  • Deploying SSIS Solutions.
  • Managing, monitoring, and administering SSIS in the enterprise.

Training Summary

Lesson 0: Introduction

  • Training overview, expectations, and introductions.

Lesson 1: Creating Your First SSIS package

  • Introduction to Business Intelligence Development Studio. Visual Studio tips and tricks, menu contents and locations.

Lesson 2: Introduction to the Data Flow Task

  • Introduction to the Data Flow Task. Connection Manager and Data Flow Task basics - source and destination adapters.

Lesson 3: The Control Flow

  • Containers, Precedence, and Work flow.
  • Transactions, restart-ability, and blocking.

Lesson 4: Loop Containers

  • Using Sequence, For Loop, and Foreach Loop Containers.

Lesson 5: Event Handlers, Logging, and Configurations

  • The OnError and OnInformation event handlers.
  • Using SSIS’s built-in logging facility to capture package execution details and statistics.
  • Using built-in package configurations to externalize variable values.

Lesson 6: Security, Deployment, and Execution

  • SSIS Package deployment options and security implications.
  • Execution options.

Lesson 7: ETL Design Patterns

  • Leveraging less-documented features of SSIS along with the Parent-Child design pattern to achieve “hands-free” custom logging and creative custom configuration.
  • ETL Instrumentation.
  • Enterprise Execution Patterns
  • Leveraging the Parent-Child design pattern to build a metadata-driven SSIS execution engine.


Registration is not yet open, but if you join SQLBits they will let you know when registration opens. I’m looking forward to visiting Great Britain. If you read this blog and attend SQLBits 9, introduce yourself! I’m the fat guy with a fu.


Published Thursday, June 30, 2011 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



GrumpyOldDBA said:

As I believe SQL Bits 9 is to be in Liverpool you don't know know how true your comment about learning English might become! < grin >

June 30, 2011 8:06 AM

Gary Mazzone said:

Andy not the Fat guy with the fu but A Well Rounded Guy with the Fu.  I know I'm the same (although my wife made be cut sown the Fu)


June 30, 2011 8:14 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement