In this unit you will learn how to develop an ETL process (extract, transform, load) with SQL Server 2008 R2 Integration Services (SSIS). Developers use SSIS packages to populate data models that are optimized for easy, high performance reporting and analytics experiences.
Hands-On Labs
Hands On Lab: Building Your First Extract-Transform-Load Process with SQL Server 2008 R2 Integration Services
This Hands On Lab covers how to design an ETL process with SQL Server 2008 R2 Integration Services to support a sales quota forecasting process. In this scenario, annual sales quotas are extracted from a mainframe and published to a remote FTP server in a series of text files. You will create an SSIS package to populate a staging table in a SQL Server database with this sales quota data, transform the extracted records, and then load the transformed records into a fact table in a dimensional data model that business users will use for query and analysis operations.
Videos
Presentation: Introducing ETL Processing with SQL Server 2008 R2 Integration Services
ETL processing (extract, transform, load) is a fundamental component of many Microsoft BI solutions. ETL enables the transformation of raw data into meaningful and actionable information. SQL Server 2008 R2 Integration Services provides a comprehensive set of tools and services for implementing ETL processing. This presentation introduces the fundamentals of ETL and SQL Server 2008 R2 Integration Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
This presentation introduces how SQL Server 2008 R2 Integration Services uses control flow to govern the order and precedence of how tasks are executed. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
This demo introduces the concept of control flow in a SQL Server 2008 R2 Integration Services package. Control flow governs the order and precedence of how tasks are executed. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Implementing Data Flow Tasks in a SQL Server 2008 R2 Integration Services Package
SQL Server 2008 R2 Integration Services includes a powerful data flow engine optimized for ETL processing. This presentation covers how to build data flow tasks which are a fundamental part of any ETL process. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Loading Fact and Dimension Tables in a SQL Server 2008 R2 Integration Services Package
Dimensional data models have unique traits that must be considered when implementing an ETL process to load them. This presentation describes how to load fact and dimension tables in a SQL Server 2008 R2 Integration Services package, including slowly changing dimensions. Presenter: Peter Myers, Mentor, Solid Quality Mentors
Demo: Implementing Data Flow in a SQL Server 2008 R2 Integration Services Package
This demo introduces the concept of data flow in a SQL Server 2008 R2 Integration Services package. Data flows can be developed to extract data from multiple sources, and then integrate and transform that data into a format that is useful for reporting and analytics. Presenter: Peter Myers, Mentor, Solid Quality Mentors.