IT:AD:TSQLT:HowTo:Test SSIS Packages
- See also:
Summary
IT:AD:SSIS packages can be tested using IT:AD:TSQLt.
Process
Developing automated unit tests is trivial as per:
Note that the Arrange phase of the unit tests will often have to Mock Tables prior to invoking the IT:AD:SSIS packages, as demonstrated here:
Alternatives
Consider the following link to investigate alternate means of testing SSIS: * IT:AD:SSIS:HowTo:Unit Test