Monday December 7, 2015 at 8:30 AM EST
Thursday December 10, 2015 at 4:30 PM EST

Add to Calendar 


Bechtel Conference Center Reston Virginia 
1801 Alexander Bell Drive
CH2M Hill Room
Reston, VA 20191

Driving Directions 


Andy Leonard 
Linchpin People 

Advanced SSIS Training with Andy Leonard & Tim Mitchell - Reston Virginia  Dec 7 - 10, 2015 

The Advanced SSIS training is one of our newer courses, but it's received excellent feecback so far.

Advanced SSIS Training Class (4-day course)

If you are looking to take your SQL Server Integration Services (SSIS) skills to the next level, this course is for you. From data flow internals to error handling patterns, and auditing/logging to catalog customization, we will illustrate and demonstrate design patterns to help bring you to the next level in your SSIS skillset.

In this course, we will discuss and demonstrate advanced SSIS concepts including:

  • Data flow internals
  • Performance design patterns
  • Learning how to fail properly
  • Security in SSIS
  • Deployment design patterns
  • Data quality
  • Metadata management patterns
  • Biml
  • Known limitations of SSIS, and workarounds for them
  • ETL data edge cases

This course is designed for data professionals with some experience (at least 1 year) with developing and maintaining SQL Server Integration Services assets. The courseware contains optional lab exercises for attendees to follow along. 

Morning coffee and lunch will be provided for all attendees.

About the presenters:

Andy Leonard

Andy Leonard serves as Data Philosopher at Andy Leonard Consulting, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SSIS Design Patterns and Managing Geeks. His background includes .Net and web application architecture and development, and SQL Server 2000-2016. You will often hear Andy talking about what a blessing it is to be able to help his customers solve their database problems.

Tim Mitchell is a business intelligence consultant, author, and trainer.  He has been working with SQL Server for a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010.  Tim is an independent BI consultant and partner with Linchpin People.  Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2.  He enjoys helping folks solve complex integration and data quality problems