SSIS Nuggets Live

2009

TL; DR

Learn secrets you might not have known about SSIS

Session Details

Over the past 4 years I have been producing a series of blog posts that I have colloquially called "SSIS Nuggets" which provide tips and tricks that may help when using SSIS. In this presentation I will be bringing some of those nuggets to life through the medium of demonstration!

3 things you'll get out of this session

Jamie Thomson's previous sessions

Real world SSDT

SQL Server Data Tools (SSDT) provide a new declarative model for building SQL Server databases. Come and learn more from Craig and Jamie who have both been using SSDT to do that for many months.

A lap around the SSIS Catalog

SQL Server Integration Services (SSIS) 2012 includes a new database referred to as the SSIS Catalog. Come to this session to learn what it does and how its going to change how you do SSIS development.

Back to the SSIS Future

A look at the new SSIS features in SQL Server code-named Denali

SSIS Dataflow Performance tuning

Building performant data flows takes more than just dragging a few boxes onto a design surface. In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.

SSIS Dataflow Performance tuning

Need to eek out a bit more oomph from your dataflows. This session might be of some use.