This course will cover how to use SQL Server Integration Services 2008 (SSIS) to manage an Extract, Transform, and Load (ETL) process. We will start by looking at the fundamental components that make up SSIS and then move onto designing packages using Business Intelligence Development Studio. We will look at solutions to common ETL challenges such as slowly changing dimensions. Topics covered are:
• Reviewing ETL Fundamentals
• Introducing SSIS Components
• Designing ETL Packages
• Slowly Changing Dimension Transformation