SSIS Unit Testing
Unit testing allows developers, users, and package lifecycle administrators to ensure that a package is performing exactly what the developer implemented and handling unexpected circumstances with predefined behavior. Unit testing allows specified inputs to be used as "source" data and evaluates the task output with expected task output thereby ensuring the package behaves correctly.
- Ensure package and / or task(s) execute as expected
- Allow user to specify the scope of each unit test and it's expected output, if any
- Show the results of the Unit Test within SSDT