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


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


A unit testing framework for SQL Server Integration Services