Practical Unit Testing for SSIS Packages

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
  • Downloads
    Video available MP4 Video HD 550 MB
  • SpeakerBIO

    John Welch works at Pragmatic Works, where he manages the development of a suite of BI products that make developing, managing, and documenting BI solutions easier. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community, and an SSAS Maestro.  John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to multiple books on SQL Server, including "Smart Business Intelligence Solutions with Microsoft SQL Server 2008" and the “SQL Server MVP Deep Dives” series.

    John writes a blog on business intelligence and SSIS topics at He is active in open source projects that help ease the development process for Microsoft BI developers, including ssisUnit (, a unit testing framework for SSIS.
  • Video