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.
This lab introduces Integration Services package design specifically to populate a fact table.
The objectives of this exercise are to:
You must have installed the following items to complete this lab:
All the requisites for this lab are verified using the Configuration Wizard. To make sure that everything is correctly configured, follow these steps.
To perform the setup steps you need to run the scripts in a command window with administrator privileges.
This Hands-On Lab comprises the following exercise:
Estimated time to complete this lab: 30 minutes.