Check it out developers, today we published the third unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights) on MSDN. I hope you will take some time from your busy schedule to learn how to develop an ETL process (extract, transform, load) with SQL Server Integration Services (SSIS). Developers use SSIS packages to populate data models that are optimized for easy, high performance reporting and analytics experiences.
Here’s an overview of the new unit:
3. Introduction to SQL Server 2008 R2 Integration Services
Presentation: Introducing ETL Processing with SQL Server 2008 R2 Integration Services
Presentation: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
Demo: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
Presentation: Implementing Data Flow Tasks in a SQL Server 2008 R2 Integration Services Package
Presentation: Loading Fact and Dimension Tables in a SQL Server 2008 R2 Integration Services Package
Demo: Implementing Data Flow in a SQL Server 2008 R2 Integration Services Package
Hands On Lab: Building Your First Extract-Transform-Load Process with SQL Server 2008 R2 Integration Services
You can find SQLInsights on the MSDN Training and Certification Resources page at the following URL:
Watch the videos and review the hands-on labs. If you want to run the demos or hands-on labs on your own computer, download and install the offline training kit. You’ll find all the SQLInsights content in the Getting Started > BI Developers page.
Next week, we’ll publish our fourth SQLInsights unit, Introduction to SQL Server 2008 R2 Reporting Services. We hope SQLInsights will help you get started developing your first Microsoft BI solution. Thanks again for your interest in SQL Server 2008 R2!