SSIS Compare data in 3 tables
Budget: $30 – $250 USD
I have a database that has 3 tables. Each table has exactly the same columns (90 columns).
The tables all have the same primary key that consists of 3 columns which make the rows unique.
The SSIS package needs to read row 1 in table 1 (all columns) and then read table 2, It needs to compare values from table 2 to table 1. If differences are found, a text file must be written out.
It must do that for 4 million rows in the tables.
The same process as above should follow (read table 1) and compare to table 3.
The tables all have the same primary key that consists of 3 columns which make the rows unique.
The SSIS package needs to read row 1 in table 1 (all columns) and then read table 2, It needs to compare values from table 2 to table 1. If differences are found, a text file must be written out.
It must do that for 4 million rows in the tables.
The same process as above should follow (read table 1) and compare to table 3.