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.|
| Lesson 2 || In this lesson, you will expand the package you created in Lesson 1 to take advantage of new looping features to extract multiple flat files into a single data flow process.|
| Lesson 3 || In this lesson, you will expand the package you created in Lesson 2 to use a package configuration, variable, and property expression to dynamically update a property.|
| Lesson 4 || In this lesson, you will expand the package you created in Lesson 3 to add logging.|
| Lesson 5 || In this lesson, you will expand the package you created in Lesson 4 to use error redirection to capture invalid data in a text file.|
| Lesson 6 || In this lesson, you will expand the package you created in Lesson 5 to deploy the project to the Integration Services server using the Project Deployment model. You will replace the configuration value with a parameter to specify the sample data location.|