• Article

Step 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

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.

Checking the Package Layout

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 AdventureWorks2008R2 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 AdventureWorks2008R2.

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