Avatar of canuckconsulting
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Use SSIS to identify matching customers

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?
SSISMicrosoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment

8/22/2022 - Mon