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.

SSIS Diff Detector

Diff Detector: data integration made easy

Our solution is easy to use, offering code-less integration between the Diff Detector component and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

Our Diff Detector component is available within the Data Quality & Comparison components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Diff Detector with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.

Other SSIS Data Quality & Comparison Components

Our Data Quality & Comparison components make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the requirements of that particular component. In addition to Diff Detector, the Data Quality & Comparison components include: