Here we show how to build a looping on incremental ETL in SSIS:
Add a BatchActualSize variable and let it get assigned the rowCount of the input:
– Add a For Loop Container around the Get DW Key and ETL tasks:
– Test it > It should be successful – repeating and resetting the following scene several times as the data allow:
Test the DW population meanwhile. Then test and document the performance per total number of rows that it processed.
If you need to log its performance, look at this article.