ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

SSIS export to excel dynamically (supports multiple tables)

Limitation of SSIS Excel Source/Destination SSIS comes with out of the box support for read/write to Excel. But its very restrictive if you want to make things dynamic because any metadata inside DataFlow cannot be changed at runtime. Here are few problems using native Excel Source or Destination. Metadata cannot be changed at runtime Datatype […]

OData Paging using SSIS JSON Source

How to read OData in SSIS – REST API Example

Introduction In this article we will learn how to use SSIS JSON Source Component┬áto fetch JSON data from OData service and perform OData Pagination of large result. In OData specification data may come in JSON format or XML format. For XML format check this article. This article will cover mostly OData JSON API example. REST […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

Welcome to ZappySys Blog

Hi All, We are excited to announce our official blog where we going to post information about Products, Features, Useful tips and Release notes. Thank You!!! ZappySys Staff

Logo REST API

How to Call REST API in SSIS – Read JSON / XML / CSV

Introduction REST API is becoming more and more popular in Data Integration landscape. If you are SSIS Developer (not a coder) and stumbled upon a question what is REST API and “how to consume API inside SSIS package?” then you are at the right place :). We encourage you to┬áread this article carefully and follow […]