A Totally New Approach to Unit Testing and Integration Testing in SSIS

With Scott Currie of Varigence and Microsoft SQL Server MVP Julie Smith

Testing is critical to managing a high-quality, predictable data lifecycle. Unfortunately, SSIS has no built-in support for test authoring and the tools for relational database testing are quite limited. As a result, most organizations forgo automated testing and instead focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues that are discovered. In this session, a new approach to unit testing (which focuses on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (which focuses on validating that the data produced by an entire sequence of transformations) will be discussed.