I would recommend you check the standard Fuzzy Lookup transformation.
In SSIS, there is DQS Cleansing transform. Is there any transform in SSIS for matching records or for finding duplicate records? in SQLSEVER 2019
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
2 answers
Sort by: Most helpful
-
-
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.