We have six different system each with a SQL Server backend. Each DB has customer information in nearly identical tables as described below:
Some customer will appear in multiple systems. So "ABC Co." might appear in System 1 and System 2. We would like to come up with a consolidated CustomerToSystem table linking a customer to the Primary Keys in the respective tables.
The problem is due to inconsistencies we cannot 100% match the customers by name and address. In System 1, the customer may be "A.B.C." while in system 2 it might be "ABC Co.". Are there any SSIS tools to help us match records?