Skip to content

Latest commit

 

History

History
30 lines (22 loc) · 1.21 KB

File metadata and controls

30 lines (22 loc) · 1.21 KB
title Task 5: Adding Data Flow Task | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology data-quality-services
ms.topic conceptual
ms.assetid ae466627-cc36-4460-a234-fe060f6f01c0
author lrtoyou1223
ms.author lle
manager craigg

Task 5: Adding Data Flow Task

In this task, you add a Data Flow Task to the control flow of SSIS package.

  1. Drag and drop Data Flow Task from SSIS Toolbox to the Control Flow tab in the SSIS Designer. If you do not see the SSIS Toolbox, click anywhere in the Control Flow tab, click SSIS on the menu bar, and click SSIS Toolbox.

    Drag-Drop Data Flow Task from SSIS Toolbox

  2. Right-click the Data Flow Task in the Control Flow tab and click Rename.

  3. Type Receive, Cleanse, Match, and Curate Supplier Data and press ENTER.

  4. Double-click the Data Flow Task to switch to the Data Flow tab.

Next Step

Task 6: Adding Excel Source to the Data Flow