ETL from the Trenches: Using SSIS in the Real World
Sure you've read the SSIS books. And sure you've seen a lot of SSIS presentations. But how do you put it all together to create a solid ETL framework for loading your data warehouse environment? In this (updated for 2010) session, we'll look at the ins and outs of a real-world ETL environment built using SSIS. We'll discuss the ETL design patterns used to handle a multi-tiered data warehouse environment with multiple data sources, different loading schedules, and different data transformation requirements. We'll also discuss how the development team responsible for the ETL environment at the Department of Veterans Affairs handles package auditing and logging, team development, package testing, and automated deployments.
Rolling Hills Enterprises, Inc.
Business Intelligence Architect
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with Microsoft Office System components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
Register Now for PASS Summit 2010!