Andrew Smith | Andrew Smith

SSIS Unit Testing

Testing of SSIS packages can be an ah-hoc, manual process that’s performed only at the package level. I.e. checking that running a whole package (or set of packages) produces the expected data.

This approach will likely not test all paths through an ETL, as well as failing to thoroughly test priority fixes […] “SSIS Unit Testing”

SSIS provides for parallelism at multiple levels: (i) by running packages concurrently, (ii) by running tasks concurrently within a package, and (iii) by running transformations concurrently within a data flow.

This post investigates parallelism within the data flow, by comparing the time taken between non-parallel and […] “Data Flow Threading”

Source Control and SSIS

Source control plays an essential part of any software development project, where ETL is no exception.

At the very least it preserves source code such that recovery is possible to a previous point in time, whilst also allowing developers to work on multiple streams of the code such that new developments are isolated […] “Source Control and SSIS”