SSIS Upsert Destination

SSIS Upsert Destination (Bulk Insert / Update)

Upsert Destination can be used to Merge / Synchronize data from source to target for Microsoft SQL Server, PostgreSql and Redshift. It supports very fast Bulk Upsert (Update or Insert) operation along and Bulk delete.

Features

  • Insert or Update (i.e. Upsert) large amount of data in few clicks
  • Supports bulk delete based on the matching rows on target
  • Sync Source data with target
  • Automatic Primary Key detection
  • Support for error handling
  • Support for SQL Server, PostgreSql and Amazon Redshift (Bulk data load operations)
  • Redirect New Rows, Updated Rows and Deleted rows to different outputs
  • Support for update by comparing actual row content rather than just key (only update if content is different)
  • Allow to Set Created Date/Time to user defined column for Insert action
  • Allow to Set Last Updated Date/Time to user defined column for Update action
  • Provide an option to control Lock Hints (Expose Custom Hints option on advanced tab)
  • Provide truncation warning during validation if data length mismatch occur between source and destination
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
See also
SSIS WebJSON File Destination JSON File Destination
SSIS JSON Generator JSON Generator Transform
SSIS Web API Destination - Send data to API Web API Destination
Custom SSIS Tasks - Export JSON File Task Export JSON File Task
Download Help File Buy View All Tasks
ScreenshotsSystem Requirements

Bulk Update / Insert using SSIS Upsert Destination

SSIS Upsert Destination - Very fast Bulk Update / Insert and Delete Operations. Merge data from Source to Target.

SSIS Upsert Destination – Very fast Bulk Update / Insert and Delete Operations. Merge data from Source to Target.

Bulk Update in SSIS using Upsert Destination

Bulk update SQL Table records in SSIS using Key match

Bulk update SQL Table records in SSIS using Key match

Bulk Delete in SSIS using Upsert Destination

SSIS Bulk delete rows in SQL Table

Bulk delete records from SQL Table (based on Key column match)

Upsert Destination Advanced Options

SSIS Upsert destination advanced options (Pre / Post SQL Command, Staging Table name)

SSIS Upsert destination advanced options (Pre / Post SQL Command, Staging Table name)

Articles / Tutorials

Click here to see all articles for [SSIS Upsert Destination] category

References

Click here to learn more about System Requirements
Download View All Tasks Like This