High Performance Dimensional Data Loads With SSIS Presentation

Just finished giving the SSIS High-Performance Dimensional Data Load presentation at SQLSaturday #59 NYC. Here are the slides in PDF format. I'll upload the Try-N-Save code and sample data later for attendees to play with.

Thanks to everyone who attended my session and thanks to Melissa D. and NJSQL for putting this together. For those who are interested in Alejandro Mesa's composable DML solution to the problem of Type 2 dimension updates, here's the complete statement from the demo:

The Try-N-Save database I used is a little more complicated to upload. I'll have to play around with scripting it out when I have time (in addition to DDL there are some tables that need to be prepopulated).