title: compare 2 tables if match update if not match insert
body: <p>I have 2 tables with same table structure. Table A is having all transaction with 3 unique key in each record. Table B have only condition base record only.</p>
  
  <p>I want compare both tables if Table B has matching record than I want to update and Table B have not matching record than insert in Table B.</p>
  
  <p>Can you please suggest best way to do it like ssis or any thing else</p>