Skip to content

task-4-creating-an-ssis-project-using-sql-server-data-tools.md

Latest commit

 

History

History
44 lines (32 loc) · 1.82 KB

task-4-creating-an-ssis-project-using-sql-server-data-tools.md

File metadata and controls

44 lines (32 loc) · 1.82 KB
title Task 4: Creating an SSIS Project using SQL Server Data Tools | Microsoft Docs
ms.custom
ms.date 04/27/2017
ms.prod sql-server-2014
ms.reviewer
ms.suite
ms.technology
data-quality-services
integration-services
master-data-services
ms.tgt_pltfrm
ms.topic conceptual
ms.assetid 8603ea91-2ec4-40b6-8070-4f824332f5d3
caps.latest.revision 7
author douglaslms
ms.author douglasl
manager craigg

Task 4: Creating an SSIS Project using SQL Server Data Tools

In this task, you create an SSIS project by using SQL Server Data Tools to automate cleansing and matching supplier data.

  1. Launch SQL Server Data Tools. Click Start, point to All Programs, expand Microsoft SQL Server 2012, and click SQL Server Data Tools.

  2. On the File menu, point to New, and click Project.

  3. Expand Business Intelligence in the Installed Templates pane, and select Integration Services.

    Visual Studio - New Project Dialog Box

  4. Select Integration Services Project in the list of project types.

  5. Type CleanseAndCurateSuppliers for Name and click OK.

  6. In Solution Explorer window, right-click Package.dtsx and select Rename. If you don’t see Solution Explorer window, click View on the menu bar and click Solution Explorer.

    Package.dtsx - Rename Menu

  7. Type CleanseAndCurate.dtsx and press ENTER. Make sure that the extension remains .dtsx.

Next Step

Task 5: Adding Data Flow Task