Using Regular Expressions in SSIS

Introduction In this short article you will learn how to write Regular expressions in SSIS (i.e. Regex) and what tool to use to test them. You will also find helpful resources on how to write more sophisticated expressions and learn more about them. For demo purpose we will use FREE SSIS Regex Parser Task to parse and […]

SSIS Advanced File System Task - Search / Replace Option -Remove invalid XML characters using Regex (Regular Expression)

How to remove invalid characters from XML using SSIS and Regex

 Introduction In this blog post you will see how to remove invalid characters from XML using SSIS. We will use search and replace feature of Advanced File System Task. Remove Invalid characters from XML Xml file specification have restriction about which characters can be part of XML data and which should be avoided. If you use […]

Using SSIS Regex Parser Task for Extracting HTML Content

Introduction In this post you will learn how to use FREE SSIS Regex Parser Task along with REST API Task to extract HTML content in few clicks. Scenario Assume that you want to search certain keywords from Bing or google and want to know how many pages found for that keyword. Url for search would […]

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

How to read Zendesk data in SSIS with REST API

Introduction Zendesk is one the most popular customer service platforms available in the market today. Zendesk offers REST API so you can interact with their cloud based service programmatically (manage or read data). The problem is not every one is programmer and not everyone has time to learn how to write C# or JAVA code […]