title: How to synchronize two tables in SSIS
body: <p>I have a scenario where i need to synchronize two tables in SSIS</p>
  
  <p><code>Table A</code> is in DATABASE A and <code>TABLE B</code> is in DATABASE B. Both tables have same schema. I need to have a SSIS package that Synchronize TABLE A with TABLE B in Such a way That</p>
  
  <p><code>1. It inserts all the records That Exist in Table A into Table B</code>    </p>
  
  <p>AND</p>
  
  <pre><code>2. Update TABLE B if Same "Key" exsit in Both but Updated records in Table A
  </code></pre>
  
  <p>For Example    Table A and B both Contains Key = 123 both Few Columns in Table A has been Updated.</p>
  
  <p>I am thinking about using Merge Joins but that helps with only insertion of New records. How i can manage to implement UPDATE thing as well</p>