title: How do I merge data from one table on one server to another table (same table name) located on another SQL server
body: <p>I need to merge a table say table1 located on server1 to table1 (same table) located on server2. </p>
  
  <p>Actually I am asked to do this via ssis package </p>