title: Delete processed records or mark them as complete
body: <p>[Newbie question.]</p>
  
  <p>I have the following scenario,</p>
  
  <ul>
  <li>Source systems publishes an event for a new customer</li>
  <li>Data warehouse consumes these events and saves them to a NewCustomer table</li>
  <li>A SSIS process will run frequently (every 10 mins), processing these into the customer DIM table, and will either mark the rows as processed or remove them from the NewCustomer table</li>
  </ul>
  
  <p>How do I mark/remove processed customers from the NewCustomer table, without removing any newly added customers which may have appeared during process?</p>