Leveraging the Database EngineIn some situations it’s appropriate to push operations down to the underlying RDBMS, that could have otherwise been performed by SSIS. This is subject to the RDBMS having the capacity available to perform these operations, but assuming it does, then this is a useful option to have to hand […] “Leveraging the Database Engine” |
Month: July 2016
SSIS Unit TestingTesting 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” |
Data Flow ThreadingSSIS 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” |