SSIS Package Testing
The SSIS Package wizards builds a suite of tests for each package. These tests ensure smooth execution, extraction, and validation of data results.
The SSIS Package wizard requires SSIS installed to build and execute the tests. Within the development environment, LegiTest only displays versions of SSIS that are currently available. The tests generated by this wizard need SSIS installed on all systems planning to run the tests.
When launched, the wizard presents an empty display. This window allows navigating to the location of the packages the user wishes to load.
Users can load packages from the following locations:
If the user wishes to deploy these tests to LegiTest Server, it must have access to these packages as well.
The select packages window allows users the ability to select the desired packages they wish to load.
If any of the packages are encrypted using a password, LegiTest requires the password to be specified.
On the specify options window, users select the types of tests to generate.
Once satisfied with the options, click "Finish". LegiTest will build several test groups and tests. The amount generated depends on the number of packages and data flows present.
Due to the nature of the tests generated, users may need to correct validition errors. These corrections typically occur within the data flow tests.