Implementing ETL Processes with SSIS
When you create a data warehouse, you spend most of the development time for the implementation of the ETL process (Extract, Transform, Load). During the ETL process you move data from various source systems to your central data warehouse where you structure it for queries issued by information workers through business intelligence tools. But how you can concrete implement a robust, scalable, and performant ETL processs with SSIS? In this session you will see some best practices how you can build an ETL process and how you can enhance it during the development time very easily. Furthermore you will see how you can use the partitioning feature of SQL Server 2008 transparently in your ETL process for the management of very large database tables.
Speaker focus
Klaus Aschenbrenner works as a Software Architect for in Vienna - Austria. Klaus has worked with the .NET Framework and especially with SQL Server 2008 from the very beginning. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. He currently travels around the world teaching clients the core concepts of SQL Server 2008. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.
Other sessions from this conference