SSIS Way To Upsert ?

I have a requirement that seems like it would be a very common requirement in many ETL scenarions:

It has been called "upsert". From wikipedia:

The SQL-like UPSERT statement inserts a record to a table in a database if the record does not exist; if the record already exists, an update operation is performed. This is not a standard SQL statement, but it is frequently used to abbreviate the equivalent pseudo-code. The term upsert is a portmanteau of update and insert and is common slang among database hackers. The SQL:2003 defines a MERGE statement that provides similar functionality.


ExampleIF FOUND
THEN UPDATE
ELSE
INSERT;



See also

merge (SQL)


Other ETL tools I am aware of support this opreation with pre-built functionality that only requires the developer to enter the key columns for the target and choices for how to handle the data when rows with matching keys are found in the stream and the target (ignore, update).

Is there an SSIS way to do this without resorting to hand coded SQL or script? Given that this is likely to be needed for many of the "fact" tables in a schema, it will end up being a _lot_ of SQL or script to write and maintain.

thanks,