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.
Presented by John Welch at SQLBits XII
MP4 Video HD 550 MB