title: Update Rows in SSIS OLEDB Destination
body: <p>I have a data flow process where I have an OLEDB Source and an OLEDB Destination like below:</p>
  
  <p><img src="https://i.stack.imgur.com/UtZ66.png" alt="Data Flow Task"></p>
  
  <p>Source merges data from two staging tables and returns a result set (say, 50K rows). These 50K rows are present in the destination table as well but are old data.</p>
  
  <pre><code>SELECT * FROM staging1
  UNION
  SELECT * FROM staging2 
  </code></pre>
  
  <p>Generally, in the OLEDB destination we insert the returned dataset from the source to destination table, but in my case I have to update the old 50K rows with these new 50K rows.</p>
  
  <p>Kind of a bulk update.</p>
  
  <p>Can anyone please let me know how I can do that? I appreciate your help.</p>