Table Difference Component | COZYROC SSIS+ components suite

The Table Difference SSIS Component is not limited by the number of records to be processed.

The Table Difference Component is an SSIS Data Flow Component designed to find differences between two tables and, in particular, to simplify the management of slowly changing dimensions.

The main advantage over the standard SCD component is the speed and ease of use.

One question arising very often in Data Warehouse programming is "What are the differences between two tables?" You have several million customers and need to decide what changes should be made. The standard SSIS toolkit provides the SCD component for handling this process, but it is of no practical use when you have to handle more than a couple thousand records. The Table Difference Component is not limited by the number of records to be processed.

This component has two inputs: one for "old data" and one for "new data". The old and new rows are compared and the result is sent to different outputs:

• Unchanged rows (same in both old and new)
• Deleted rows (appear in old but not in new)
• New rows (appear in new but not in old)
• Updated rows (appear in both old and new, but there are changes)

Benchmark

**This component was tested with 5.5 million records and 25 comparison columns** on a dual core AMD machine with 4GB of RAM and a standard SATA disk. The comparison process was complete in 7 minutes.

COZYROC SSIS+ Components Suite is free for download and development within Visual Studio

✔️ Free developer license.

✔️ Support for SQL Server 2012, 2014, 2016, 2017, 2019, 2022

✔️ COZYROC SSIS+ suite includes more than 250 tasks and SSIS components for ETL and Data Integration

✔️ A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud

✔️ One-time migrations and data transfers are completely FREE.

The COZYROC SSIS+ components suite also includes:

The powerful and elegant Data Flow Task Plus, not found in any other competitive product on the market. Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with COZYROC's REST adapters.

Check the SSIS Data Flow Task demo video in our Youtube channel.

See also:

• COZYROC SSIS REST framework video. With the COZYROC SSIS REST framework you can connect to any Web service and consume any Web API. Free for download and development https://www.cozyroc.com/ssis/rest

• COZYROC SORT Plus SSIS component video. With COZYROC’s Sort Plus SSIS component, you can sort ANY amount of data and any number of records. Free for download and development https://www.cozyroc.com/ssis/sort

• For a full compatibility list and more information about the COZYROC SSIS+ Components, please visit the COZYROC website

Try COZYROC Cloud for free. The COZYROC.Cloud hosted service allows you to Lift & Shift legacy SSIS workloads to the cloud in a breeze at a very affordable price which includes a license for the COZYROC SSIS+ suite.

Get in touch with us:

• For support or any questions connect with us