Sql-server – How to perform automated unit testing in SSIS packages

sql-serverssisunit-testing

How can I unit test SSIS packages? I want to be able to create and maintain unit tests for various components such as the workflow tasks, data flow tasks, event handlers, etc.

Are there any existing techniques, frameworks, and/or tools that can be used?

Best Solution

ssisUnit

A unit testing framework for SQL Server Integration Services