title: SSIS - Insert new rows, update rows
body: <p>What is the "best" or recommended method to check which row has changed and which rows already exist?
  I found few articles but I am not sure if these methods are the best:</p>
  
  <p><a href="http://www.ssistalk.com/2007/03/09/ssis-using-a-checksum-to-determine-if-a-row-has-changed/" rel="noreferrer">http://www.ssistalk.com/2007/03/09/ssis-using-a-checksum-to-determine-if-a-row-has-changed/</a> <br>
  <a href="http://itssmee.wordpress.com/2010/10/03/ssis-insert-and-update-rows-in-a-table-based-on-the-contents-of-a-excel-file/" rel="noreferrer">http://itssmee.wordpress.com/2010/10/03/ssis-insert-and-update-rows-in-a-table-based-on-the-contents-of-a-excel-file/</a><br>
  <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">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</a></p>
  
  <p>I need this for really large amounts of data from 25 databases</p>
  
  <p>EDIT:</p>
  
  <p>In this article...
  <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">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</a>
  ... how do I add part for updating records? Do I use OLE DB Command or there's something else in this article I don't see?</p>