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

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

Welcome to ZappySys Blog

Hi All, We are excited to announce our official blog where we going to post information about Products, Features, Useful tips and Release notes. Thank You!!! ZappySys Staff

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