Table-B sits on Server "A" and I want to push any data added to this table(table-B) to Table-X which sits on Server "Z". What would be the best options, setup an SSIS package to copy the data from Table-B to Table-X, (but this will only give me new inserted records that was added to Table-B, not the modify field(s) Or put a trigger(Insert/Update) on Table-B to write to Table-X, if possible. The structure of Table-B & Table-X is completely different, there is about 9/11 field I want from Table-B. Any suggestion is appreciated. Thanks