SSIS MongoDB Array Upsert Example (Update / Insert Array Items based on custom lookup condition)

Update or Insert – Upsert MongoDB Array Items using SSIS

Introduction In our previous blog post we saw how to update / delete mongodb array item. Now let’s look at how to Upsert MongoDB Array Items (i.e. Insert Item if not found in Array else Update existing record). Upsert into nested MongoDB Array requires two step process, unfortunately there is no easy way to do […]

SSIS Upsert Destination Example - Bulk Insert or Update in SQL Server (Merge Records)

SSIS PowerPack v2.9 released (Upsert Destination, Salesforce BULK API and more…)

What’s New In this release we focused on mainly providing high quality and super fast Upsert Destination (Bulk Update, Insert and Delete / Merge) for SQL Server. We also added Salesforce BULK API support for Salesforce Destination. Full Notes: Version [Feb 08, 2019] New Features/Improvements NEW: Amazon S3 CSV File Source, FTP, Azure – […]

Using SSIS JSON Generator Transform with Batch Option (Multiple Records in a single document)

How to batch REST API requests in SSIS (Bulk Operation)

Introduction In our previous article we saw how to POST data to REST API using few different ways. Now let’s go one step further and discuss another common scenario to batch REST API requests in SSIS. For efficient data transfer many API provides you to submit multiple records in a single request. In this article […]

Load data from Exact Online into SQL Server using SSIS

Introduction In this article, you will learn how to load data from Exact Online into SQL Server using SSIS. Exact Online is a popular CRM, ERP and HRM tool which also lets you manage your finances. As an example, we will use Exact Online contacts as data to load it into a SQL Server database. […]