title: SSIS - Delete rows
body: <p>I'm new to SSIS and need help on this one. I found an <a href="http://consultingblogs.emc.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx" rel="noreferrer">article</a> which describes how to detect rows which exist and which have changed. The part that I'm missing is how to update rows that changed. I found some articles which say that it's also good solution to delete records which have changed and insert new recordset. The thing is I don't know how to do that step of deleting (red box).</p>
  
  <p>Any suggestions?</p>
  
  <p><img src="https://i.stack.imgur.com/yPsdk.png" alt="enter image description here"></p>