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

Question

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:

• Unit testing of SSIS Package with tSQLt
• How to test the SSIS Packages?
• Unit testing data flow in a ssis package

Answer 1

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

• BUILDING AN SSIS TESTING FRAMEWORK

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

• SSIS:Automated Unit Testing

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

• How to get all errors of all SSIS packages in a solution