Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. We 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 will also highlight how to automate the testing of SSIS packages, using the open source ssisUnit framework. We'll cover several of the common questions about automated unit testing, including: - How to handle test data - How to set up the environment for multiple developers - How to make tests flexible - How to ensure that the tests remain valuable over time
Register Now for PASS Community Summit 2008!