SSIS Installation Acceptance Testing

Installation of systems like ERP / SAP generally requires clients to sign off documents for acceptance testing. But this is generally not required in case of a typical installation for SSIS. Recently I came across a scenario where I was required to provide documentation and deliverables for acceptance testing of SSIS Installation at a client location.

Thanks to Microsoft, that it ships was a dozen of samples. Two of the samples which can be used as a base of such acceptance testing are the "AWDataWareHouseRefersh" and "Data Cleaning".

Execution of "AWDataWareHouseRefersh" sample tests components like Sequence Container, For Loop Container, For Each Loop Container, Execute SQL Task, Bulk Insert Task, Data Flow Task and connection adapters as well.

Execution of "Data Cleaning" sample tests components like Lookup, Fuzzy Lookup, Derived Column, Union All, Conditional Split, Data Flow Task and connection adapters as well.

I feel this much is enough for basic smoke testing of a proper SSIS installation.