John Welch
agilebi.com/jwelch
John Welch works at SentryOne, where he leads the development of a suite of products that empower the Microsoft data professional to achieve breakthrough performance in their solutions.
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.