22-25 April 2026 
SQLBits 2014
Practical Unit Testing for SSIS Packages
Unit and integration testing for SSIS packages can be challenging. Come to this session to learn how to leverage open-source tools to drive the testing of your packages and the resulting data.
Unit testing is a widely accepted best practice, yet it is
difficult to do well with SSIS packages. This session will focus on a brief
introduction to unit testing principles, and then focus on examples of testing
your SSIS packages using ssisUnit. It will cover in depth how to set up your
development environment to support test driven development and what techniques
can be used to make this practical for SSIS. We’ll show how to handle test
data, how to set up the environment for multiple developers, how to make tests
flexible, and how to ensure that the tests remain valuable over time.
Speakers
John Welch's previous sessions
Continuous Delivery for Data Warehouses and Marts
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Practical Unit Testing for SSIS Packages
Unit and integration testing for SSIS packages can be challenging. Come to this session to learn how to leverage open-source tools to drive the testing of your packages and the resulting data.
Unit Testing SSIS Packages
Unit testing is incredibly beneficial, but is very difficult to do effectively in SSIS. If you have wanted to do this, but aren't sure how, this session will cover the options and demonstrate a free tool for unit testing packages.
Handling Advanced Data Warehouse Scenarios in SSIS
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.