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.

(no tags)