Tag Archives: SSIS Export JSON Task

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

Posted on by

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

JSON File Destination - Generate JSON in SSIS from multiple inputs

5 Ways to Export JSON from SQL Server using SSIS

Posted on by

Introduction SQL Server 2012 and all previous versions lacking native JSON support, same theory is true for their ETL Platform SSIS. If you are one of them who wants to export JSON from SQL Server or any other RDBMS like MySQL, Oracle then you can easily output complex JSON using any of the following components. Five ways of […]