29

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:

Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
mattrowsboats
  • 582
  • 1
  • 6
  • 14

1 Answers1

18

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

Masoud R
  • 102
  • 3
  • 10
Hadi
  • 36,233
  • 13
  • 65
  • 124