Duplicate Detector
via SSIS Productivity Pack
Compares rows within a data source to identify duplicate rows based on an approximate (fuzzy) or exact match.
Download Purchase
What other productivity tools are available?
Click here for more solutions.
Developer Productivity Tools
Duplicate Detector Component
The Duplicate Detector SSIS data flow component that can be used to compare rows within a single data source and identify duplicate rows.
With Duplicate Detector component, comparison filters can be added for fields in the source that determine how they will be compared.
The Duplicate Detector component, part of the SSIS Productivity Pack, can use approximate (fuzzy) or exact match comparison to compare rows.
Duplicate Detection Made Easy
Duplicate detector offers code-less duplicate detection capabilities within SSIS data flows. Built on Microsoft SQL Server Integration Services (SSIS), a high-performance and flexible ETL platform, it allows your team to leverage existing skills and technology investments. The drag-and-drop interface makes it simple to configure reliable duplicate identification processes in minutes.
The component, part of the Data Quality & Comparison Components in our Productivity Pack, enables you to compare rows within a single data source and identify duplicates using either exact match or approximate (fuzzy) matching. Developers can configure comparison filters for selected fields, specifying how each should be evaluated, giving precise control over the matching logic
See our full product offerings for more information.
More Conversion Components
Our SSIS Data Quality & Comparison Components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to Duplicate Detector Component, the Data Quality & Comparison Components include:
Address Parser
Address Verification
Data Profiler
