Deep dive into SQL Server Integration Services (SSIS) 2012 internals
David Peter Hansen
Duration: 60 minutes
Track: B - Business Intelligence & Big Data
You have worked with SQL Server Integration Services (SSIS) for a few years, but would like to know what is happening behind the scene. Join this session to get a deep dive into the internals of SSIS, and find out what is happening when your packages are executed. You will learn about the data flow engine, what buffers are used for, how the different transformations behave, and what execution trees are and why they are important.
Understanding the SSIS internals is not only very interesting in itself, but will also make you able to respond to design and performance problems – as well as solve them.