Task 3: Testing the Lesson 1 Basic Package

In this lesson, you have done the following tasks:

  • Created a new Integration Services project.

  • Run the SQL Server Import and Export Wizard to create the basic package.

  • Verified and updated the values of locale sensitive properties.

Your package is now complete! It is time to test your package.

Important noteImportant

The first time you run the package, the task named Drop table(s) SQL Task will fail. This behavior is expected. The reason the task fails is that the package attempts to drop and re-create the ProspectiveCustomers table; however, the first time that the package runs the table does not exist and the DROP statement fails. This does not cause the package to fail because the precedence constraint between the Drop table(s) SQL Task and Preparation SQL tasks has been set to Completion rather than Success.

Before you test the package you should verify that the control and data flows in the lesson 1 package, Basic Package Lesson 1.dtsx, contain the objects shown in the following diagrams.

Control Flow

Control flow for Basic Lesson 1 package

Data Flow

Data flow for the Basic Lesson 1 package

Also, the package should include the following two connection managers. One connects to the Excel workbook file Customers.xls and the other one connects to the AdventureWorks database.

Connection managers for the Basic Lesson 1 package

To run the Lesson 1 package

  1. In Solution Explorer, click Basic Package Lesson 1.dtsx.

  2. On the Debug menu, click Start Debugging.

    The package will run, resulting in 809 rows successfully added into the ProspectiveCustomers table in AdventureWorks.

  3. After the package has completed running, on the Debug menu, click Stop Debugging.

Lesson 2: Enhancing the Basic Package

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