title: SSIS: How to get the number of updated and deleted rows in an audit?
body: <p>Imagine that you want to save in a variable the number of rows the were updated or deleted in a table.
  ‌
  This is the steps that i did:
  First, in the Control flow i created a Data Flow Task. 
  Them, in the Data Flow, i created a source(in my case is a excel file), then i proceeded to create two variables to count those rows- countDeleted and countUpdated, then connected the variables to two  row count transformations, and them connected my destination (OLE DB).</p>
  
  <p>Now in the control flow, what do i do??
  Create a SQL execute task?? or a Script task?? What is the best way to do it?? What is the piece of code to use??</p>
  
  <p>Thanks for youy help.
  P‌S: i only have 4 weeks off SSIS, sorry for my noobieness :)</p>