Lesson 1: Creating the Basic Package

In this lesson, you will create a basic package by using the SQL Server Import and Export Wizard. The package selects and extracts data from an Excel spreadsheet and writes that data to the ProspectiveCustomers table in the AdventureWorks2008R2 sample database. The table is defined in the wizard and created when you run the package.

The SQL Server Import and Export Wizard will be run in Business Intelligence Development Studio and you will launch the wizard from an Integration Services project.

After you complete the SQL Server Import and Export Wizard the package is added to the Integration Services project. You will open the package in SSIS Designer, the Integration Services graphical tool for building complex packages, and verify that certain properties of the package are configured correctly.

Finally, you will test the package by running it in Business Intelligence Development Studio.

Important

This tutorial requires the AdventureWorks2008R2 sample database. For more information on installing and deploying AdventureWorks2008R2, see Considerations for Installing SQL Server Samples and Sample Databases.

Lesson Tasks

This lesson contains the following tasks:

• Step 1: Creating the Integration Services Project

• Step 2: Running the Wizard to Create the Basic Package

• Step 3: Testing the Lesson 1 Basic Package

Start the Lesson

Step 1: Creating the Integration Services Project