You can use Execute SQL Task in control flow to do a bulk update which is faster than doing a row-by-row update. You can write an update statement joining the...

You can use conditional split task to direct rows into different tables based on conditions