Dataflow with Upsert

Dataflows need a way to reference a table as input, do a comparison and perform upserts on through the data destination in a single dataflow. Instead of having to rely on truncate/reload with replace or creating a stored procedure to do upserts on a staged table of changes.