How do i get the number of updated and deleted rows in an audit table? (SSIS)

• luis.amaro1234

  Grasshopper

  Points: 22

  More actions

  November 25, 2018 at 10:09 am

  #376478

  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).
  
  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??

  Thanks for youy help.
  PS: i only have 4 weeks off SSIS, sorry for my noobieness

• Mike01

  SSChampion

  Points: 11412

  More actions

  November 27, 2018 at 7:08 am

  #2014642

  not sure what the issue is.  The rowcount variables should be populated once the data flow task runs

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/