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 […]

SSIS – Loading data into MongoDB (Upsert, Delete, Update)

Introduction MongoDB is one of the most poplar NoSQL database out there. In this article you will learn how to use ZappySys MongoDB Destination Connector to perform various bulk operations on MongoDB such as Insert, Update, Delete and Upsert. If you wish to learn how to Update MongoDB Array items then check this blog post instread. […]

Read MongoDB data from array (extract nested sub documents)

Introduction In this post you will learn how to read MongoDB data from Array. We recently introduced new JSON Path expression feature in SSIS MongoDB Source Connector to extract nested information from MongoDB documents.   Read documents from Array in MongoDB By default SSIS MongoDB Source Connector doesn’t support extracting data using JSON Path expression. So if […]

How to query MongoDB by date or ISODate

Introduction ZappySys provides high performance drag and drop connectors for MongoDB Integration. In our previous post we discussed how to query/load MongoDB data (Insert, Update, Delete, Upsert). In this post you will see how to query MongoDB by date (or ISODate) using SSIS MongoDB Source. To see full detail about possible query syntax see online help. MongoDB […]