Share via

SSIS DQS Cleaning Component Error

RITISH BEDI 0 Reputation points
Aug 30, 2023, 2:52 PM

I am unable to add DQS Cleaning Component , Its showing me this error that " Component Language Runtime detected an invalid program" So I need the solution regarding the same..User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,652 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 40,901 Reputation points
    Aug 31, 2023, 7:05 AM

    Hi @RITISH BEDI,

    What's your version of VS?

    Could you please try to update the VS or repair VS?

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


  2. Yitzhak Khabinsky 26,461 Reputation points
    Sep 1, 2023, 3:07 PM

    Hi @RITISH BEDI,

    1. VS2022 and, specially, SQL Server Integration Services Projects 2022 extension for it still have lots of bugs. Please try to download and install its latest version 1.1: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices
    2. If what I said above won't work for you, the only solution is to switch to VS2019 and its SQL Server Integration Services Projects extension: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.