Task Factory Feature: Upsert Destination SSIS Component 

Upsert Destination

Do you need to insert and update data into SQL Server or Oracle? The Task Factory Upsert Destination conditionally updates or inserts data up to 700x faster than the traditional SSIS pattern that employs row-by-row logic.

Task Factory provides dozens of high-performance SSIS components, including the Upsert Destination, that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.

 

Download Free Trial

Learn More About Task Factory Pricing

Task Factory Modules

Choose from 13 Task Factory modules that address specific SSIS tasks and data sources. Learn More

 

Task Factory

Includes 70+ high-performing SSIS components that help you efficiently manage ETL pipelines. Learn More

 

Task Factory Azure Data Factory 

Includes 65+ high-performing SSIS components that help you efficiently manage ETL pipelines in Azure Data Factory (ADF). Learn More
 

Conditionally Insert and Update (Upsert) Data with SSIS

 

Task Factory Upsert Data with SSIS

Use the easy Task Factory Upsert Destination which has been written specifically for performance and to speed up your development time. The component can be configured in seconds, and it can handle many more scenarios like 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 will 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 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 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

Task Factory Licensing Options

A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.

Compare Editions

Task Factory Modules

Annual Subscription License

 

$425–$795

Per Server


Learn More

Choose from more than a dozen Task Factory modules, each of which delivers high-performance components targeted to a specific SSIS task.

Task Factory

Annual Subscription License

 

$1,245

Per Server
Includes annual maintenance

Buy

70+ SSIS tasks and components

Task Factory Azure Data Factory

Annual Subscription License

 

$1,495 

Per ADF Node

 
Buy

65+ SSIS tasks and components