How to get update row count ?

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  May 15, 2015 at 12:02 am

  #317499

  Hi ,

  In my SSIS Package, Conditional split to get the new row and updated row.

  1-New RecordsISNULL(Equipment_Id)

  2-Update RecordsEquipment_Id > 0

  To insert new record I am using OLEDB Destination and for update OLEDB Command.

  My question is for UPDATE

  every time it will give the count of all record whos Equipment_Id > 0.

  how to get only the latest update record count.

  regards,

  Vipin jha

• michal.lisinski

  SSCertifiable

  Points: 7201

  More actions

  May 15, 2015 at 4:05 am

  #1798130

  Hi Vipin

  Imho it's enough to add Row Count between Conditional Split and OLE DB Command,

  or you set has another condition in Update statement (OLE DB Command)w which limits

  number of updated rows.

  Regards

  Mike