How to read / write Google SpreadSheet using SSIS

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

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

How to import XML into SQL Server using SSIS

Introduction In this post you will learn how to import XML file into target such as SQL Server, CSV, Excel, Oracle. Converting or Importing XML requires flattening XML structure (i.e. hierarchy) sometimes we refer this process as de-normalization.  Parsing XML can be tricky depending on how many levels you have and from which level you need data. […]

Start / Stop Fiddler Capture

Tutorial – How to use Fiddler to analyze HTTP Web Requests (Tips)

Introduction Fiddler is one the most popular tool to inspect your Http Traffic. This tool helps you to test REST API / SOAP Web requests very easily. If you are using SSIS PowerPack or REST API ODBC Drivers you will find this post really useful to debug various REST API integration issues. When you run Fiddler […]

Create new Amazon DynamoDB Connection in SSIS - Use Amazon DynamoDB Execute SQL Task - List Tables Example

How to Read / Write Amazon DynamoDB in SSIS

Introduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.). We will discuss how to use SSIS DynamoDB Source Connector […]

Tip – How to fix UI scaling issue on Windows 10 and 7

Problem Many customers reported issue regarding UI not scaling correctly on certain machines (windows 10 and windows 7). If you have similar issue then most likely its due to System Font Scale (DPI) is set to higher than 100%. Perform following steps to verify/fix it. Sometimes maximizing the window will show correct UI elements so […]

How to Insert Multiple Documents into MongoDB using SSIS

Introduction In this post you will learn how to use MongoDB ExecuteSQL Task for SSIS to insert multiple documents into MongoDB collection using SSIS. This task can be used to perform any DDL or DML operations for MongoDB natively inside SSIS without using any command line utilities. It gives you flexibility and security of SSIS. […]

Create SOAP Request Body from WSDL (Using SoapUI tool)

Calling SOAP Web Service in SSIS (XML Source)

Introduction In this article, you will learn how to call SOAP Web Service in SSIS. We will use drag and drop approach to consume SOAP Webservice using SSIS XML Source Connector. This same XML Connector can be used to consume data from local XML Files (wild card allowed e.g. *.xml) or you can consume XML stored in […]

How to get data from Google AdWords using SSIS

Introduction Google AdWords is one of the most popular Advertise Platforms. In this article, you will learn how to get data from Google AdWords by calling Google AdWords Web Service method and using drag and drop SSIS XML/SOAP connector (No coding required :)). Google AdWords Web Services allows retrieving various data such as account info, campaigns; […]