unable to see DQS Cleansing transformation after upgrading SSIS 2017 to SSIS 2022.

Agnel, Jasmine 0 Reputation points
2023-01-20T23:11:53+00:00

I am not able to see DQS Cleansing transformation after upgrading SSIS 2017 to SSIS 2022 in DATAFLOW task. I already tried uninstalling and reinstalled SSDT and VS 2022.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 17,875 Reputation points
    2023-04-28T02:47:26.9333333+00:00

    If you are not able to see the DQS Cleansing transformation after upgrading SSIS 2017 to SSIS 2022 in the Data Flow task, there are a few things you can check:

    Verify that the DQS component is installed: Check if the DQS component is installed in your SSIS 2022 installation. You can do this by going to the "Extensions" menu in Visual Studio and selecting "Manage Extensions." In the "Installed" tab, verify that the "SQL Server Integration Services Projects" extension is installed.

    Check if DQS Cleansing transformation is enabled: Check if the DQS Cleansing transformation is enabled in your SSIS 2022 installation. You can do this by going to the "Tools" menu in Visual Studio and selecting "Options." In the "Integration Services" section, check if the "Enable Data Quality Services (DQS) Cleansing component" checkbox is selected.

    Ensure that the project targets SSIS 2022: Ensure that the project you are working on is targeting SSIS 2022. You can do this by going to the project properties and selecting the "General" tab. In the "TargetServerVersion" dropdown, select "SQL Server 2022."

    Try resetting the toolbox: If the DQS Cleansing transformation is still not visible, try resetting the toolbox. You can do this by right-clicking on the toolbox and selecting "Reset Toolbox."