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
That’s how you make it dynamic.
Note: All URLs must return the same format of data. Otherwise on runtime you may start getting empty columns or errors.