Hands On Lab: Building Your First Extract-Transform-Load Process with SQL Server 2008 R2 Integration ServicesVersion: 1.0 DescriptionThis 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. OverviewThis lab introduces Integration Services package design specifically to populate a fact table. ObjectivesThe objectives of this exercise are to:
System RequirementsYou must have installed the following items to complete this lab:
SetupAll the requisites for this lab are verified using the Configuration Wizard. To make sure that everything is correctly configured, follow these steps.
Note:
To perform the setup steps you need to run the scripts in a command window with administrator privileges.
Cleanup
ExercisesThis Hands-On Lab comprises the following exercise:
Estimated time to complete this lab: 30 minutes. |