• You can get your hands dirty in SSIS. Following is the link for Stairway to Integration Services[/url] by Andy Leonard

    As per your current case, you just need to move the data from Source Table to the Destination Table.

    Just like importing/Export Wizard in SQL SEVER. If you want to use the SSIS Approach you need to the following

    1) Create a Log Table in Server1.Database1 and use this table in the Trigger.

    2) Create a replica Log Table on Server2.Database2.

    3) For kick start sample ssis package is attached. (change the file extention from txt to dtsx).

    Hope it helps.