SSIS Unit Test

BI xPress ›› Features ››
Parent Previous Next

SSIS Unit Testing


Important Note:

As of the 2018.2 release, SSIS Unit Testing will be deprecated and no longer supported.

In future releases, the SSIS Unit Testing feature may be excluded entirely and users should use LegiTest for their SSIS 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.

Feature Highlights

  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

Important Note:

The SSIS Unit Testing feature only supports SSIS versions 2005, 2008, 2008 R2, 2012 and 2014.

For users wishing to create tests using SSIS 2016, use LegiTest, instead.

Additionally, Pragmatic Workbench (32-bit) must be used when running SSIS Unit Test Suites on a machine that only contains SSDT for Visual Studio 2015.

Table of Contents


Important Note:

If you are attempting to run a unit tests against SSIS Package(s) that contain Third-Party Component(s), the machine in which BI xPress' SSIS UNit Testing is installed on will also require the Third-Party Component(s) installed on it as well.

Tutorial Video