Yes, actually if you see my comments I mentioned that I am performing UPINSERT logic on the basis of staging table which hold around 50 K records daily basis.So was thinking to handle the split on the same.As was having the staging table and did not want to insert derived columns additionally.But not sure about the performance.
I would still use the data flow for the inserts. Do a conditional split to a staging table with just the rows that need to be updated and go ahead and do your inserts in the pipeline. Then you can use an Execute SQL Task to do a set-based update. The alternative would be an OLE DB Command to do your updates but that will be RBAR. So this is one case where a staging table makes a lot of sense.