Readme_Creating a Simple ETL Package Tutorial: Lesson Packages

This sample works only with SQL Server 2012. The sample works with the SQL Server 2012 version of the AdventureWorks DW database. To install this database, go to Adventure Works for SQL Server 2012.

The Lesson 1, Lesson 2, Lesson 3, Lesson 4, Lesson 5, and Lesson 6 packages are completed packages from the SSIS Tutorial: Creating a Simple ETL Package. Each lesson package builds on the version of the package created in the earlier tutorial lessons. These topics provide detailed information about the functionality of each package. The topics are located in the Integration Services Tutorials section of MSDN library.

You can open and run these packages outside the tutorial. You need to do the following to ensure that the packages run successfully.
  • Run the Lesson 1 package first to create the NewFactCurrencyRate table.
  • For the Lesson 1 and Lesson 2 packages, update the configuration of the Flat File connection manager to point to the location of the sample data on your machine.
  • For the Lesson 5 package, create the XML configuration file. For instructions on how to create the file, see Lesson 5: Adding Package Configurations for the Package Deployment Model.

The following table provides a brief summary of each lesson package.

Lessons Description
Lesson 1 A simple ETL package that extracts data from a single flat file, transforms the data by using Lookup transformations, and finally loads the result into a fact table.

Last edited Dec 18, 2012 at 12:55 AM by sabottaca, version 5


No comments yet.