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

Question

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.

Answer 1

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."