SQLBits 2010

SSIS Fieldnotes

After years of careful observation and recording of the Species SSIS, Genus ETL, in both natural and artificial environments, I’ve gathered a large collection of fieldnotes. Find out the little decisions that get made that can have big impacts on you project later on. What option to choose for better performance, or better management, and what are the trade-offs? This session won’t just focus on holy grail of performance, it will review the way you build and use SSIS taking into account the on going maintenance and management aspects as well.
After years of careful observation and recording of the Species SSIS, Genus ETL, in both natural and artificial environments, I’ve gathered a large collection of fieldnotes. Find out the little decisions that get made that can have big impacts on your project later on. What option to choose for better performance, or better management, and what are the trade-offs? This session won’t just focus on the holy grail of performance, it will review the way you build packages and use SSIS taking into account the on going maintenance and management aspects as well.