Skip to content

open-integration-services-projects-in-data-quality-client.md

Latest commit

 

History

History
65 lines (39 loc) · 4.81 KB

open-integration-services-projects-in-data-quality-client.md

File metadata and controls

65 lines (39 loc) · 4.81 KB
title Open Integration Services (SSIS) projects in Data Quality Client
description Learn how to open a SQL Server Integration Services (SSIS) project using the Data Quality Client for SQL Server Data Quality Services.
author chugugrace
ms.author chugu
ms.date 03/01/2017
ms.service sql
ms.subservice data-quality-services
ms.topic how-to
ms.custom
build-2025

Open Integration Services Projects in Data Quality Client

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

The DQS Cleansing component in Integration Services enables you to run a cleansing project in batch mode. However, at times you might want to review the cleansing results in an Integration Services package similar to how you can review the cleansing results in the Manage and View Results tab of a cleansing activity in a data quality project in DQS. DQS enables you to open Integration Services projects in [!INCLUDEssDQSClient] just like any other data quality project from the Open project screen, and have an interactive cleansing experience of the cleansing results in an Integration Services project.

Before You Begin

Limitations and Restrictions

  • Only completed Integration Services projects are available in the Open project screen in [!INCLUDEssDQSClient]. Failed or running projects are not available in the Open project screen.

  • Integration Services projects open at the interactive cleansing stage (Manage View and Results tab) in [!INCLUDEssDQSClient]. You cannot go to the Cleanse or Map tabs. You can only go to the Export tab by clicking Next.

  • You cannot delete a locked Integration Services project from [!INCLUDEssDQSClient]. You must first unlock it to delete.

Prerequisites

You must have successfully completed running an Integration Services project containing a package with a DQS Cleansing component to see and open it in [!INCLUDEssDQSClient].

Security

Permissions

You must have the dqs_kb_editor or dqs_kb_operator role on the DQS_MAIN database to open an Integration Services project.

Open an Integration Services Project

  1. [!INCLUDEssDQSInitialStep] Run the Data Quality Client Application.

  2. In the [!INCLUDEssDQSClient] home screen, click Open Data Quality Project. The Open project screen appears.

  3. In the Open project screen, you can identify an Integration Services project in either of the following ways:

    1. Project Name: Integration Services projects are listed using the following naming terminology: "Package.DQS Cleansing_<DATE><TIME>_{GUID}." Every time you successfully run the same package in [!INCLUDEssBIDevStudioFull], a new project is listed in the Open project screen.

    2. Project Type: Integration Services projects have SSIS as the project type in the Open project screen.

    Select a project, and click Next.

  4. The Integration Services project opens at the interactive cleansing stage (Manage View and Results tab). You can perform an interactive cleansing on the data in the Integration Services project. For detailed information about the Manage and View Results tab, see Interactive Cleansing Stage in Cleanse Data Using DQS (Internal) Knowledge.

  5. Click Next to go to the Export tab where you can export the processed data to any of the following: a new table in the SQL Server database, a .csv file, or an Excel file. For detailed information about the Export tab, see Export Stage in Cleanse Data Using DQS (Internal) Knowledge

  6. After exporting the data, click Finish to close the Integration Services project.

See Also

DQS Cleansing Transformation
Integration Services(SSIS)Projects