Home » SSIS PowerPack » SSIS Components » SSIS JSON File Destination

Calling SharePoint 365 REST API in SSIS

Posted on May 28, 2018June 14, 2023 by ZappySys Team

Introduction to REST API with SharePoint in SSIS Using REST API with SharePoint in SSIS is a common requirement to Administer SharePoint. SharePoint 365 is a nice Microsoft application in the Cloud used to share documents and collaborate with the company. You can have schedules, projects, documents and more shared using a Web platform. In addition, […]

JSON File Destination - Generate JSON in SSIS from multiple inputs

5 Ways to Export JSON from SQL Server using SSIS

Posted on December 7, 2015January 8, 2023 by ZappySys

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