How to call Amazon MWS API using SSIS

Introduction In this post you will learn how to call Amazon MWS API (Amazon Marketplace Web Service) or Amazon Product Advertising API using SSIS PowerPack. Using drag and drop approach you can consume data from Amazon MWS XML Web service. In this post we will use ZappySys XML Source connector to read data from Amazon MWS […]

REST API Looping/Pagination via URL Page Number Parameter (Loop until last page detected)

Understanding REST API Pagination in SSIS / ODBC Drivers

Introduction In this blog post, you will learn concepts and patterns about REST API Pagination (JSON / XML / SOAP or CSV API). We will describe methods and steps to implement REST API Pagination in SSIS PowerPack or  ODBC PowerPack API Drivers without coding. Both Products share similar user interface with minor difference. For example purpose […]

SSIS Advanced File System Task - get file list as ADO.net Recordset into variable

Get list of files in SSIS for Looping

Introduction In this post you will learn how to use Advanced File System Task to get list of files and folders into variable. Advanced File System Task is significantly better than native SSIS File System Task How to get list of files in SSIS Most simplest way to get list of files in SSIS is […]

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