Diff Detector Component
via SSIS Productivity Pack
Enables the comparison between two sources; a primary and a secondary source.
What other productivity tools are available?
Click here for more solutions.
Developer Productivity Tools
Diff Detector Component
The Diff Detector component is a SSIS data flow pipeline component that can be used to compare fields from an 'Old Data' input and 'New Data' input.
With Diff Detector component, rows from the inputs are matched using a business key (simple or compound key) and compared to each other to determine if the rows are unchanged, changed, deleted from the primary data source or added in the secondary data source.
The Diff Detector component, part of the SSIS Productivity Pack, can use approximate (fuzzy) or exact match comparison to identify differences in rows.
Change Detection Made Easy
Diff Detector offers code-less data comparison 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 powerful comparison workflows in minutes.
The component, part of the Data Quality & Comparison Components in the Productivity Pack, enables you to compare data between two sources: a primary (old data) and a secondary (new data). Rows are matched using a business key (simple or compound) and evaluated to determine if they are unchanged, changed, deleted from the primary source, or added in the secondary source. The component supports both exact and approximate (fuzzy) matching to provide flexible and accurate comparison results..
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 Diff Detector Component, the Data Quality & Comparison Components include:
Address Parser
Address Verification
Data Profiler
