Skip to content

Latest commit

 

History

History
42 lines (25 loc) · 1.63 KB

lesson-5-4-testing-the-lesson-5-tutorial-package.md

File metadata and controls

42 lines (25 loc) · 1.63 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic
Step 4: Test the Lesson 5 package
Lesson 5-4: Test the Lesson 5 package
chugugrace
chugu
01/08/2019
sql
integration-services
tutorial

Lesson 5-4: Test the Lesson 5 package

[!INCLUDEsqlserver-ssis]

At run time, your package obtains the value for the Directory property from a configuration variable, rather than from the directory name specified when you created the package. The value of the variable comes from the SSISTutorial.dtsConfig XML file.

To verify that the package updates the Directory property with the new value during run time, run the package. Because only three sample data files are in the new directory, the data flow runs only three times.

Checking the Package Layout

Before you test the package, verify that the control and data flows in the Lesson 5 package are similar to the objects shown in the following diagrams:

Control Flow

Control flow in package

Data Flow

Data flow in package

Test the Lesson 5 package

  1. On the Debug menu, select Start Debugging.

  2. After the package has completed running, on the Debug menu, select Stop Debugging.

Next lesson

Lesson 6: Use parameters with the Project Deployment Model in SSIS