How to read / write Google SpreadSheet using SSIS

Posted on September 24, 2016November 1, 2021 by ZappySys

Introduction In this post you will learn how to get data from Google SpreadSheet (REST API) using SSIS. We will use drag and drop REST API connectors from SSIS PowerPack. No need to download any SDK or learn programming language (e.g. JAVA, C#, Ruby, Python) when you use SSIS PowerPack Connectors. We will use Google […]

SSIS Base64 Encode, Decode using SSIS Logging Task (Without coding convert plain text to base 64 string)

SSIS Base64 Encode Decode without Coding

Posted on September 7, 2016September 5, 2023 by ZappySys

Introduction In this post you will learn how to use FREE SSIS Logging Task to perform ssis base64 encode decode and save to Variable or File (i.e. convert Base64 Encoded value to plain text or encode plain text to base64) . You can also use many other format specifiers found here How to invoke Placeholder […]

SSIS Rest API Task - Extract data from single XML node using XPath expression (Namespace used)

SSIS – Extract single XML node using XPath from SOAP response

Posted on September 7, 2016January 20, 2023 by ZappySys

Introduction In this post you will learn how to extract single XML node value from your XML web response (SOAP Web service call) using XPath expression in SSIS REST API Web Service Task and e XML Parser Task. This article assumes you have basic knowledge how to call REST API or SOAP Web service in SSIS. If […]