Home » ssis json parser transform

How to extract multiple arrays from MongoDB using SSIS

Posted on January 12, 2017October 12, 2017 by ZappySys

Since MongoDB Source supports only one output you cannot select two different hierarchies as your filter criteria. However solution is easy. You can perform following steps to achieve similar result without fetching data twice with multiple sources. Same steps described below can be applied for JSON Source (read more here) Steps – Extract multiple […]

Reading JSON Arrays from file / REST API

Posted on January 11, 2016December 23, 2020 by ZappySys

Introduction REST API is becoming more and more common and with that you will see explosion in use of JSON data format. One of the questions we get a lot is “How to extract or read array from JSON data file” or “How to read multiple arrays from JSON data“. Example : Store JSON document […]