In SSIS, there is DQS Cleansing transform. Is there any transform in SSIS for matching records or for finding duplicate records? in SQLSEVER 2019

khaled moussa 1 Reputation point
2021-12-26T11:59:23.987+00:00

HI Team,

I am trying to automate DQS Matching component in SSIS 2019. I already found DQS Matching Task on Code plex Link: https://techcommunity.microsoft.com/t5/sql-server-integration-services/automating-the-data-matching-process-in-sql-server-data-quality/ba-p/388175, but its only compatible with SQL SERVER 2012.
So Is there any replacement for this task that's compatible with SQL SERVER 2019.

Thanks,
Khaled

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

2 answers

Sort by: Most helpful
  1. COZYROC 101 Reputation points
    2021-12-26T17:13:14.167+00:00

    I would recommend you check the standard Fuzzy Lookup transformation.

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2021-12-27T05:44:25.56+00:00

    Hi @khaled moussa ,

    You may check if this helps on your issue.

    Also here is a same thread about ssis-data-flow-how-to-remove-duplicate-rows-but-log-the-duplicates-in-ssis.

    If I misunderstand your issue, please incorrect me.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    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.