Upsert Destination SSIS Component

Use the easy Task Factory Upsert Destination written specifically for performance and to speed up your development time. The component can be configured typically in seconds, and it can handle many more scenarios such as looking for row differences or logging the number of inserts and updates to a variable.

Speed up your SSIS package run by up to 700x. Because there are no row-by-row operations to update data, Upsert Destination can take a load that might have taken an hour down to under a minute in many cases. Task Factory components use SSIS for what it's good for and SQL for what it's good at by using merge code behind the scenes and updating up to tens of thousands of rows in the time SSIS would have updated a single row.

Feature highlights:

• Upsert data 700x faster into Oracle or SQL Server
• Configures typically in seconds
• Bulk updates by checking each column automatically or using a modified date
• Can use the high-performance T-SQL MERGE statement to modify the data