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.