title: SSIS: How to transfer data from table A to table B and then update table A flag column for each row
body: <p>I need to crate a package in SSIS which will selectively transfer data from Table A to table B based on a flag in Table A and after the transfer update the flag in Table A.</p>
  
  <p>Please advice on the approach to this scenario and the different ways in which this can be done effectively.</p>
  
  <p>I would also like to mention that i have never worked on SSIS packages before.</p>