Skip to content

lesson-1-9-testing-the-lesson-1-tutorial-package.md

Latest commit

 

History

History
58 lines (35 loc) · 2.04 KB

lesson-1-9-testing-the-lesson-1-tutorial-package.md

File metadata and controls

58 lines (35 loc) · 2.04 KB
description Step 9: Test the Lesson 1 tutorial package
title Step 9: Test the Lesson 1 tutorial package | Microsoft Docs
ms.custom
ms.date 01/03/2019
ms.prod sql
ms.prod_service integration-services
ms.reviewer
ms.technology integration-services
ms.topic tutorial
ms.assetid 9aee7acf-797b-46f2-830d-80ab64a9f0b6
author chugugrace
ms.author chugu

Lesson 1-9: Test the Lesson 1 package

[!INCLUDEsqlserver-ssis]

In this tutorial, you've done the following tasks:

  • Created a new [!INCLUDEssIS] project.

  • Configured the connection managers for the package to connect to the source and destination data.

  • Added a data flow that takes the data from a flat file source, performs the necessary Lookup transformations on the data, and configures the data for the destination.

Your package is now complete and ready to test!

Check the package components

Before you test the package, verify that the control and data flows in the Lesson 1 package contain the objects shown in the following diagrams.

Control Flow

Control flow in package

Data Flow

Data flow in package

Run the Lesson 1 package

  1. On the Debug menu, select Start Debugging.

    The package runs, resulting in 1,097 rows successfully added into the NewFactCurrencyRate fact table in AdventureWorksDW2012. To verify this result, select the Data Flow tab.

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

Go to next lesson

Lesson 2: Add looping with SSIS

See also

Execution of projects and packages