Feature_Part_of-Product_Logos_Task_Factory (1)

 

Task Factory Feature: Upsert SSIS

 

 
FREE TRIAL
BUY

 

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.

HELPFUL LINKS

Help Documentation

Data Sheet

 

Please reach out to us for more information or a personalized demo.

+1 (704) 895-6241

 

FREE TRIAL

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 Buying Options

 

Contains 60+ tasks, connection managers, sources and Destinations for SSIS. You can compare editions here. Task Factory does not require a license while you're running packages in Visual Studio.

 

Standard

$1,795

Per Server

+

$359

for the first year of annual maintenance

$2,154

due at checkout

30+ SSIS tasks and components

BUY

Pro

$2,495

Per Server

+

$499

for the first year of annual maintenance

$2,994

due at checkout

60+ SSIS tasks and components

BUY