How to make Path / URL dynamic in SSIS

Problem

Most of SSIS PowerPack components support simple text placeholders engine to make things dynamic without using Complex Steps of SSIS Expression Engine. So let’s look at how to make Path / URL or other input values dynamic in SSIS. To show you how to do that we will use JSON Source component, but basically, you can use it in any ZappySys PowerPack component that has URL option, including XML Source.

 

 

Create a variable

Don’t forget to set the default value, because it will be used to construct an URL in design time. A call to that URL will be made to figure out the columns.

Make an HTTP address dynamic

Creating a Dynamic Request Body

To make a dynamic body in ZappySys (e.g., in an HTTP request or API call using the REST API Task or JSON Source or XML Source), you typically use placeholders or expressions in the request body.

Here’s how to create a dynamic body:


Example: Dynamic JSON Body using Variables

{{User::MyVariable}} is a variable placeholder.

Dynamic Body

Dynamic Body

That’s How You Make It Dynamic

By combining placeholders and expressions in the URL and body fields, ZappySys lets you build fully dynamic API requests. Whether you’re passing parameters, looping through records, or injecting runtime values—this approach keeps your integration flexible, scalable, and efficient.

Posted in SSIS Tips & How-Tos and tagged , , , , , , .