In this lesson, you 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. In this lesson, you create a simple ETL package that extracts data from a single flat file, transforms the data using lookup transformations and finally loads the result into a fact table destination. Lesson 1: Create a Project and Basic Package with SSIS If this tutorial is your first time working with packages or the new development environment, we recommend that you begin with Lesson1.
By using the completed packages, you can skip ahead and begin the tutorial at a later lesson if you like. When you install the sample data that the tutorial uses, you also install the completed versions of the packages that you create in each lesson of the tutorial. In following lessons, the package is expanded to demonstrate looping, package configurations, logging, and error flow. The package that you create takes data from a flat file, reformats the data, and then inserts the reformatted data into a fact table. In this tutorial, you learn how to use SSIS Designer to create a simple Microsoft SQL Server Integration Services package.
0 kommentar(er)
