IESSIS2: Immersion Event on Advanced SQL Server Integration Services

(Retired – no longer offered as a public class)


This 400-level, 5-day, advanced SSIS training class was created to help technology professionals take their SQL Server Integration Services (SSIS) skills to the next level. Developed by Tim Mitchell and Andy Leonard, the training is focused around lectures and emphasizes a demonstration approach.

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 SSIS Design Patterns to help bring you to the next level in your SSIS skill set.

Target audience: Database professionals, application developers, and business intelligence practitioners interested in expanding their existing SSIS skill set.

Prerequisites: One year experience with SQL Server and SQL Server Integration Services is required before attending this training.

Instructor: Andy Leonard, Tim Mitchell

Need Help Justifying Training? Here’s a letter to your boss explaining why SQLskills training is worthwhile and a list of community blog posts about our classes.


Module 1: The SSIS Catalog

  • Catalog overview
  • Deployment
  • Execution
  • Logging

Module 2: Managing Security in SSIS

  • Package security
  • Securing sensitive parameters
  • Runtime security
  • Securing the catalog itself

Module 3: Performance Design Patterns for SSIS

  • Overview of SSIS performance
  • Troubleshooting methods
  • Performance tips

Module 4: What’s New in SSIS 2016

  • Overview of new features

Module 5: SSIS Testing Patterns

  • Why test?
  • Design patterns for test-ready packages
  • Design time vs. runtime testing
  • Performance testing
  • Testing error logic
  • Instrumenting SSIS

Module 6: Scripting in SSIS

  • Overview of scripting in SSIS
  • Scripting tools

Module 7: Managing Data Quality in SSIS

  • Overview of Data Quality Services
  • Practical applications
  • Limitations

Module 8: Data Flow Internals

  • Inside the Data Flow
  • Incremental Loads
  • Performance Strategy

Module 9: Advanced Load Patterns in SSIS

  • XML
  • OData
  • Incremental loads

Module 10: Error Handling

  • What could go wrong?
  • Design patterns
  • Control Flow tools
  • Data Flow tools

Module 11: Gotchas in SSIS

  • Overview
  • Problem domains

Module 12: Incremental Load Design Patterns

  • What are incremental loads
  • Source incremental load patterns
  • Destination incremental load patterns
  • Slowly-changing dimension patterns

Module 13: Biml

  • Introduction
  • Biml Language Structure
  • BimlScript Language Structure
  • Metadata Management
  • Patterns


If you have any questions not answered by our F.A.Q., please contact us.