title: SSIS - How to process one row at a time
body: <p>Destination table has 1 row already existing with IsCurrent = 1 
  Data source returns 2 rows
  I want to process one row at a time 
  so for 1st row Do lookup and set IsCurrent to 1 and set IsCurrent for already existing row to 0
  Then I want to repeat this for 2nd row
  so at the end I have 3 rows and 3rd row has IsCurrent to 1 and other two are set to 0</p>
  
  <p>But since both the rows get processed at same time I am unable to do above. </p>
  
  <p>I could do this using script task but I was hoping if there is an easier way to do it.</p>
  
  <p>Trying to do SCD without using SSIS SCD transformation</p>