X
Task Factory

Update and Insert (Upsert) Data 700x Faster

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.

 

Conditionally Insert and Update (Upsert) Data with SSIS

Feature Image

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

Testimonial What People Say About Task Factory

“We got Task Factory mostly because of Pragmatic Works reputation for the service they provide and the specific need of a secure SFTP task.”

Matt Cushing
Matt Cushing
Loews Corporation

“At the University of Calgary, I can say with confidence that halfway into the conversion effort, using Task Factory has been one of our smartest and most cost-effective software acquisitions in recent memory.”

Gabriel Gray
Gabriel Gray
University of Calgary

Our Clients 96% of fortune 100 companies trust pragmatic works:

Our StatsSome of our cool facts

  • 200x
    More frequent deployments
  • 24x
    Faster recovery from failures
  • 3x
    Lower change failure rate
  • 2555x
    Shorter lead times

Articles & Tutorials

Incrementally Loading Data from SalesForce.com

Most people pull data from SalesForce.com into a central reporting database to do more advanced reporting. This blog shows you my method for pulling data into a single repository for further reporting. Read More

Webinars & Videos

 
Upserting Data into SQL Server with SSIS
 
On the Board - The Upsert Pattern in SSIS
 
Oracle Upsert Destination - Troubleshooting Made Easy
 
Task Factory Oracle Upsert
Accelerate SSIS today
Task Factory Pro Edition
Help Documentation
Download Data Sheet

Please reach out to us to start your digital transformation journey.

Task Factory
Call Us At: (904) 413-1911

Contains 65+ 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.