Is it possible to write an SSIS package using a connector such as KingswaySoft and to merge two records? I want to merge 2 records from my SSIS package and need to know how to accomplish that through update statements?
If this is possible, what fields would I need to update on the master record?