This project has moved and is read-only. For the latest updates, please go here.

ssisUnit v1.0

Rating:        Based on 3 ratings
Reviewed:  3 reviews
Downloads: 11357
Released: Aug 31, 2008
Updated: Dec 15, 2008 by johnwelch
Dev status: Stable Help Icon

Recommended Download

Application ssisUnitSetup2008.msi
application, 393K, uploaded Aug 30, 2008 - 8994 downloads

Other Available Downloads

Application ssisUnitSetup2005.msi
application, 395K, uploaded Aug 30, 2008 - 1332 downloads
Application ssisUnitSetup2005_revised.msi
application, 395K, uploaded Dec 15, 2008 - 1031 downloads

Release Notes

Use the ssisUnitSetup2005_revised.msi installer if you do not have .NET 3.5 installed.

New Features:
  • TestSuiteSetup and TestSuiteTeardown are now included in the unit test definition. These allow you to run setup and teardown operations (creating a table, loading test data) once at the beginning of entire set of tests, and to tear them down at the end.
  • There are also TestSetup and TestTeardown elements, that allow you to perform setup and teardown for a specific test.
  • A GUI has been added for creating the tests.
  • Package Lists are now supported, and are the preferred way to reference packages from tests. As part of this functionality, packages that live in SQL Server can now be referenced.
  • The Tests will now properly report errors thrown from Tasks.
  • A number of minor issues have been corrected.

Reviews for this release

Decent for integration testing. Useless for Unit testing. Way better than alternative (nothing). - No mocking or stubbing - get/set limited to scalar - no get/set of system variables - no assert success/failure of tasks or other flow of control - no way to test conditional precedent constraints - no db support - no debugging for broken / bad ssisUnit files
by ahammon on Oct 1, 2009 at 1:04 AM
Very good SSIS Testing System - testing the packages has been a real issue to date. I can see this coming in very handy! Thanks, PK :-)
by paulkohler on Jun 16, 2009 at 12:50 AM
Finally a way to unit test my SSIS packages !! I was worried when I saw it was XML, but glad to say there is now a UI to simplify things But why isn't there something in Visual Studio ?
by steveculshaw on Feb 8, 2009 at 5:23 PM