This course will cover how to use SQL Server Integration Services 2008 (SSIS) to manage an Extract, Transform, and Load (ETL) process. Ola Ekdahl with IT Mentors starts by looking at the fundamental components that make up SSIS and then moves onto designing packages using Business Intelligence Development Studio. You 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