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
Here’s how to create a dynamic body:
Example: Dynamic JSON Body using Variables
1 2 3 4 |
{ "name": "{{User::MyVariable}}, "status": "active" } |
{{User::MyVariable}} is a variable placeholder.
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.