Saturday October 14th 2017

Categories

Insider

Archives

Tutorial: Creating a Simple ETL Package

We recently did a hands on experience on using sql server 2008 Integration Services by creating a package. We followed the microsoft tutorial  and found it a very good to get started with Integration Services 2008. We would like  to share it with our reader, so lets enjoy;

In this tutorial, you will learn how to use SSIS Designer to create a simple Microsoft SQL Server Integration Services package. 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 following lessons, the package will be expanded to demonstrate looping, package configurations, logging and error flow.

When you install the sample data that the tutorial uses, you also install the completed versions of the packages that you will create in each lesson of the tutorial. By using the completed packages, you can skip ahead and begin the tutorial at a later lesson if you like. If this is your first time working with packages or the new development environment, we recommend that you begin with Lesson1.

Read More