SSIS - How to perform a unit or integration test?
Problem: 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? Solution: 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 me...