Source Code for ETL performance test

There was a lot of response on the ETL performance test that was published last week so I have published the source code for all the tests at the below link.

Happy testing, also please feel free to share any interesting finds. I have highlighted the first DFT to show the impact of not pre sizing the database files when performing ETL.

30 min ETL brought down to 1 min just by preventing auto growth.

Source code

https://s3-ap-southeast-1.amazonaws.com/sourcecode.enabledbusiness.com/SSiS+ETL+performance/ETL+Tutor.zip

Database backup File

https://s3-ap-southeast-1.amazonaws.com/sourcecode.enabledbusiness.com/SSiS+ETL+performance/etl

Actual data (BIG FILE)

https://s3-ap-southeast-1.amazonaws.com/sourcecode.enabledbusiness.com/SSiS+ETL+performance/fileoutput.zip