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.
SQL Server Consultant
Klaus Aschenbrenner works as an Solution Architect HP in Vienna - Austria. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008.
Register Now for PASS Summit 2010!