Testing the Lesson 1 Basic Package

New: 14 April 2006

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.

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

  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.

Community Additions