Step 4: Testing the Lesson 5 Tutorial Package

At run time, your package will obtain the value for the Directory property from a variable updated at run time, rather than using the original directory name that you specified when you created the package. The value of the variable is populated by the SSISTutorial.dtsConfig file.

To verify that the package updates the Directory property with the new value during run time, simply execute the package. Because only three sample data files were copied to the new directory, the data flow will run only three times, rather than iterate through the 14 files in the original folder.

Before you test the package you should verify that the control and data flows in the Lesson 3 package contains the objects shown in the following diagrams. The control flow should be identical to the control flow in lesson 2. The data flow should be identical to the data flow in lessons 1 and 2.

Control Flow

Control flow in package

Data Flow

Data flow in package

To test the Lesson 3 tutorial package

  1. On the Debug menu, click Start Debugging.

  2. After the package has completed running, on the Debug menu, and then click Stop Debugging.

Community Additions