Working with HTTP Cookies in SSIS

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

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

OData Paging using SSIS – REST API Paging 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 […]

SSIS dataflow Expression alternative - Using Variable Placeholders

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

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

Call REST API using SSIS Web Service Task / JSON / XML Source

Introduction In this article you will learn how to call REST API using SSIS Web Service Task , JSON Source Connector or XML Source Connector. You will also learn how to perform HTTP GET Request and HTTP POST Request without knowing any programming languages (e.g. C#, JAVA, Python)… simply do Drag and Drop in SSIS. What is […]