I creted this presentation for collegues after implementing partitioning in an ETL Project, taking execution time down from eight hours to 20 minutes. It later became a SQL Saturday presentation for SQL Saturday #433 in Gothenburg. It’s been tweaked on and off ever since. First upload of presentation material to this site is from GroupBy Conference October 9th 2019.
Installation and execution
Deploy SSIS-project to SSISDB.
Run the “Create data”-package, either from VS or from SSISDB. Easiest is to run the relevant code in “Execute SSIS package.sql” (after some tweaking of paths).
Now you’re ready. There’s some back and forth between setup-script and executing the different versions of the packages. SSIS packages should be completely dynamic,
so that creating new indexes on the Sales-table should be picked up automagically by the Execute SQL-tasks.