O'Reilly logo

SQL Server Integration Services by Bill Hamilton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Example 1: Data Flow

This example walks you through building a simple SSIS package that extracts data from the Sales.SalesOrderHeader table in the AdventureWorks database and writes it to a flat file.

Create an SSIS Project

First we need to create a new SSIS project. An SSIS project is a container used to manage one or more SSIS packages. Follow these steps:

  1. Launch Business Intelligence Development Studio by selecting All Programs → Microsoft SQL Server 2005 → SQL Server Business Intelligence Development Studio from the Start menu.

  2. Select File → New → Project... from the main menu to open the New Project dialog.

  3. Specify Business Intelligence Projects as the project type, select the Integration Services Project template, name the project SSIS Shortcut, and specify its location (or accept the default location). The completed New Project dialog is shown in the following figure.

    New Project Dialog

    Figure 5. New Project Dialog

  4. Press the OK button to create the new project and dismiss the New Project dialog. A designer for the new package is created in Business Intelligence Development Studio as shown in the following figure.

    New package designer

    Figure 6. New package designer

  5. Right-click the package name Package.dtsx in the Solution Explorer pane and select Rename from the context menu. Change the name to Example1.dtsx. This will display ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required