Task 4: Testing the Lesson 3 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.

Checking the Package Layout

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 the package

Data Flow

Data flow in the 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.

Next Lesson

Lesson 4: Adding Logging

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.