Hands On Lab: Building Your First Extract-Transform-Load ...

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 ... ................
................