No description, website, or topics provided.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
SSISUnit PackageRef constructor can now contain the project reference (primari… Jul 26, 2018
SsisUnit.Base Updates to expression application Jul 28, 2014
SsisUnit.TestComponents Added support for SSIS 2017 Feb 20, 2018
SsisUnit.Tests Added several Dataset persisting tests Aug 1, 2018
SsisUnit Normalized line endings Jul 30, 2018
SsisUnitDesign Added DataTable metadata tab to Dataset browser Jul 30, 2018
SsisUnitSetup Code Reorg Sep 18, 2013
SsisUnitSetup2008 Code Reorg Sep 18, 2013
SsisUnitTestRunner Added support for SSIS 2017 Feb 20, 2018
SsisUnitTestRunnerUI Changed the help/About address from codeplex to github Jul 30, 2018
docs Typo Nov 1, 2017
packages Updates for 2014 Apr 9, 2014
ssisUnit2012Setup Added support for SSIS 2017 Feb 20, 2018
ssisUnitTestDb Added support for SSIS 2017 Feb 20, 2018
.gitattributes Added support for SSIS 2017 Feb 20, 2018
.gitignore Added support for SSIS 2017 Feb 20, 2018
LocalTestRun.testrunconfig Updates for older versions Aug 21, 2014
README.md Update README.md Jun 6, 2018
SSISUnit.sln Updates for older versions Aug 21, 2014
SSISUnit.vsmdi Updates for older versions Aug 21, 2014
SSISUnit_SQL2008.sln Update to include an enum on the CommandCompleted/Failed event args t… Nov 14, 2013
SSISUnit_SQL2012.sln Updates for 2014 Apr 9, 2014
SSISUnit_SQL2014.sln Added logging Aug 18, 2014
SSISUnit_SQL2017.sln Added support for SSIS 2017 Feb 20, 2018
SsisUnit.testsettings No commit message Nov 14, 2013
license.md Move from CodePlex Nov 1, 2017

README.md

ssisUnit

ssisUnit is a unit testing framework for SQL Server Integration Services. It is loosely based on the xUnit family of unit testing frameworks, but is tailored to better support the SSIS environment. One of the bigger differences is that you do not have to write code to create the unit tests. Instead, we have taken a declarative approach to specifying the unit tests. The test information is stored in an XML file. Since many SSIS developers do not have a background in developing desktop or web applications, we felt it was important to deliver something that did not require an understanding of .NET development to use.

ssisUnit supports task level testing in SSIS. Any control flow task can have a set of tests created around it. This level of granularity in testing can make testing complex packages much easier.

The ssisUnit test framework has evolved into LegiTest. If you are looking for:

  • coverage for databases (anything with an OLE DB or ODBC provider)
  • SQL Server Analysis Services (tabular and multidimensional)
  • SQL Server Reporting Services
  • a more robust user interface and an enhanced user experience

then please take a look at LegiTest. It supports testing SSIS packages, cubes, databases, and reports, and adds some great user experience features, along with offering other valuable tools for BI developers.

More Info

Please report issues using the Issues tracker in GitHub.