Search code examples
sql-serverunit-testingssisintegration-testingetl

How do I unit test and integration test my SSIS packages?


This question mentions two libraries, both of which aren't maintained and one has broken links to the source and documentation.

SSISUnit was last updated in 2008 and SSIStester has broken links in the documentation and hasn't been updated since 2013.

The answers on social.msdn.microsoft.com also generally point to one of those two libraries, or some sort of custom solution.

Are there any other options?


2018-10-09 Bounty Update

Is there any updates that are related to newer versions of SSIS (2015+)?

I have already checked similar questions:


Solution

  • The most Basic way to perform a SSIS Unit Testing is to create your own testing package. Example below:

    The Most popular Tools to perform SSIS Unit Testing are the ones you listed:

    • SSISUnit
    • SSISTester

    But after making a deep search i found a new way that is BizUnit. BizUnit Framework which is predominantly used for the Biz Unit testing can be customized to test SSIS Package as well. More info in the link below

    Also if you mean by testing Package Validation (metadata , connections , ...etc), you can follow my answer in this SO question