Staging Upsert Output

Description

The Staging Upsert Output step first looks up a row in a table using one or more lookup keys. If the row can’t be found, it inserts the row. If it can be found and the fields to update are the same, nothing is done. If they are not all the same, the row in the table is updated if the “Variation number” is larger the existing one.

Option	Description
Step name	Name of the step.
Connection	Select predefined database connection
Target schema	The name of the Schema for the table to write data to. This is important for data sources that allow for table names with dots ’.’ in it.
Target table	Name of the target table.