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 A Day of SSIS 2012 (Precon) at SQL Saturday Dallas

I am honored to present a day-long preconference before SQL Saturday 255 (Dallas) entitled A Day of SSIS 2012.

Please register here. I’m excited to visit the Dallas area! Here’s some information about the precon – I hope to see you there!

Training Description

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 2012 package

  • Introduction to SQL Server Data Tools. 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 2012’s built-in Catalog logging facility to capture package execution details and statistics.
  • Using built-in package configurations to externalize variable values.
  • Using SSIS 2012 Parameters and Environments.

Lesson 6: Security, Deployment, and Execution

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

Lesson 7: Hacking the SSIS 2012 Catalog

  • Understand the SSIS 2012 Catalog design.
  • Extending the SSIS 212 Catalog.

Lesson 8: Enterprise Execution Patterns

  • Leveraging the SSIS 2012 Catalog and the Parent-Child design pattern to build a metadata-driven SSIS execution engine.
  • Extending SSIS with Custom Tasks
  • Data integration dashboards: One approach to data integration management.


Published Wednesday, August 28, 2013 8:30 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



Charles Martin said:

I enjoyed the presentation immensely.  As a first time attendee to any "precon", I was a little bit uncertain about one thing:  "should I bring my laptop?"  It was unclear if computers would be provided so I did bring my work laptop (which I felt appropriate as this precon was paid for by work and there was an off-chance I might need to be called in so I had it on hand just in case).  I almost didn't bring any and I feel I'd have lost a little bit had I not.  I was running SSIS 2008 and got to see that 95% of what was shown/demo'ed was applicable in the older version (we're upgrading soon, but until then...).  

I just wanted to point out that a note along the lines of "Laptops/Computers are not provided for attendees, but not required.  If bringing a laptop, be advised that wi-fi access may be provided, but not guaranteed.  It would be best if you wish to perform some of the exercises on your own machine as the instructor does them, that you have the software already installed on your machine (Express versions can be found <here>.)"

November 5, 2013 10:23 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement