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.

Standard
$1495
Per server
Buy
Pro
$1995
Per server
Buy
X

Update and Insert (Upsert) Data 700x Faster

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

 
  • Placeholder_Image

     

     "We got Task Factory mostly because of PragmaticWorks reputation for the service they provide and the specific need of a secure SFTP task.- Matt Cushing, Loews Corporation"

    CONDITIONALLY INSERT OR UPDATE (UPSERT) DATA IN SSIS

    There are two ways to conditionally insert or update data in SQL Server and Oracle in SSIS.

    1) Spending tons of time building logic to detect row changes and using slower row-by-row components or separate SQL statements.

    2) Use the easy Task Factory Upsert Destination written specifically for performance and easy development time. The component can be configured in just seconds and it can handle many more scenarios like looking for row differences or logging the number of inserts and updates to a variable.

  • Short on time? Let us show you real-world usage of our SFTP Task with a Live Product Demo

    (904) 413-1911

     

    REQUEST A LIVE DEMO
  • WHY USE TASK FACTORY UPSERT DESTINATION?

    Placeholder_Image

    1) It's insanely easy to use. In just a few seconds, you will have complex logic designed. No hand-writing SQL statements and no specialized coding patterns.

    2) 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.