How to read Twitter data in SSIS using REST API Call

Introduction In this article you will how to Read Twitter data in SSIS using SSIS JSON Source and SSIS REST API Web Service Task. You will also learn about latest OAuth 2.0 Protocol to simplify REST API access. Twitter REST API Authentication In order to fetch any data from twitter using OAuth REST API calls […]

JSONPath Expression Examples – JSON Cheatsheet (SSIS / ODBC)

What is JSONPath expression JSONPath expression is an expression language to filter JSON Data. Its a similar concept to XPath expression in XML but has limited features compared to XPath. If you are extracting data from REST API Services using SSIS JSON / XML Source or ODBC JSON / XML Driver then you will quickly realize […]

Working with HTTP Cookies in SSIS or ODBC

Introduction In this post you will learn how to Parse Cookies from Response and Pass Cookies to any Web Requests. SSIS PowerPack v1.8.2 Introduced new feature to send and receive cookies from HTTP Web Request/Response. We will use SSIS REST API Task to parse cookie values and then send cookies along with HTTP Web Request. Cookies […]

SSIS REST API Task - Response Header Mapping Grid

SSIS REST API Task – Mapping Response Header to Variable

In this post you will learn how to save Response header value to SSIS variable using SSIS REST API Task SSIS PowerPack v1.8.2 Introduced new feature for mapping Response Header to variable. When you click Test Request/Response button all response headers will be parsed into Response Header Grid with default [NOT-MAPPED] status. If you wish […]

SSIS export to excel dynamically (supports multiple tables)

Limitations of the SSIS Excel Source/Destination SSIS comes with out-of-the-box support for reading and writing to Excel. However, it’s very restrictive if you want to make things dynamic, as any metadata inside DataFlow cannot be changed at runtime. Here are a few problems with using the native Excel Source or Destination. Metadata cannot be changed […]

How to read OData in SSIS – REST API Example

Introduction In this article, we will learn how to utilize the SSIS JSON Source Component to retrieve JSON data from an OData service and perform OData pagination on significant results. According to the OData specification, data can be presented in either JSON or XML format. For the XML format, refer to this article. This article primarily […]

How to set SSIS Data Flow component property using expression and variable

Introduction SSIS PowerPack supports various methods for making things dynamic. Sometimes you have to consume JSON Data from a Dynamic URL. There are 3 different ways you can make JSON Source URL Dynamic. Use Expression on the DirectPath property of the JSON Source (SSIS Data Flow Expression) Use variable placeholders directly inside URL (Only works […]

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 The REST API is becoming increasingly popular in the Data Integration landscape. If you are an SSIS Developer (not a coder) and stumbled upon a question What is REST API and how to consume API inside an SSIS package?” then you are at the right place :). We encourage you to read this article carefully and […]