SSIS: How to transfer data from table A to table B and then update table A flag column for each row
- by renegadeMind
Hi,
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.
Please advice on the approach to this scenario and the different ways in which this can be done effectively.