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 noteImportant

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.

Task 1: Creating the Integration Services Project

Integration Services icon (small) 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:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions