SSIS MongoDB ExecuteSQL Task

MongoDB ExecuteSQL Task can be used to execute ad-hoc commands for MongoDB (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete or Run JavaScript and shell commands.)

Features

Intuitive user interface with many examples makes MongoDB learning super easy and fast
Call DDL statements such as Create/Drop table
Execute DML statements such as Select/Insert/Update/Delete
Support for calling Database, Collection, Server MongoDB commands using JavaScript
Saving RawResult (e.g. JSON response) into SSIS variable
Extract SingleValue from response such as count or size from getStats function response.
Save in FullResultset as ADO.net dataset (e.g. select * from mycollection) can be stored as ADO.net recordset (can be used with ForEachLoop container task for looping).

Watch this video on YouTube

In visual studio just Drag and Drop ZS MongoDB ExecuteSQL Task in design panel

Insert document into MongoDB with an example query

You can Insert Document using MongoDB ExecuteSQL Task with few Steps

Get the collection/tables name from a database

You can use a variable in db to get all collections/tables from all your databases with a foreach loop.

Call server side MongoDB JavaScript functions

Get Documents using Where condition

Articles / Tutorials

How to call MongoDB JavaScript using SSIS
How to read MongoDB data from an array (extract nested subdocuments)
How to write MongoDB Aggregation Queries in SSIS (Group By)
How to loading SQL data into MongoDB (Insert, Upsert, Delete, Update)
How to update MongoDB Array Items using SSIS

Update MongoDB Array Items using SSIS

Introduction In our previous blog post we saw how to perform Read and Write operations in MongoDB using SSIS (i.e. Bulk Update, Delete, Upsert, Insert). In this post we specifically focus on how to update MongoDB Array items / elements using SSIS. To make things simple to follow we have used JSON Source to produce […]

How to call MongoDB JavaScript using SSIS

Introduction SSIS PowerPack comes with great features for MongoDB Integration Scenarios but in this post we will focus on how to call MongoDB Javascript (Server side) using SSIS. For this purpose we will use SSIS MongoDB Execute SQL Task This powerful task not only easy to use but it supports calling any valid MongoDB commands […]

How to Insert Multiple Documents into MongoDB using SSIS

Introduction In this post you will learn how to use MongoDB ExecuteSQL Task for SSIS to insert multiple documents into MongoDB collection using SSIS. This task can be used to perform any DDL or DML operations for MongoDB natively inside SSIS without using any command line utilities. It gives you flexibility and security of SSIS. […]

How to add / remove MongoDB User in SSIS

Introduction In this blog post, you will learn how to call MongoDB Shell Commands from SSIS using MongoDB ExecuteSQL task Some of the use cases of calling MongoDB shell commands are listed here. How to call MongoDB Shell Commands in SSIS Download and install SSIS PowerPack from here From toolbox of SSIS designer dragÂ Â ZS […]