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 AdventureWorks 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 AdventureWorks sample database. For more information on installing and deploying AdventureWorks, see Considerations for Installing SQL Server Samples and Sample Databases.

Lesson Tasks

This lesson contains the following tasks:

• Task 1: Creating the Integration Services Project

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

• Task 3: Testing the Lesson 1 Basic Package

Start the Lesson

Task 1: Creating the Integration Services Project

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.