REST Destination: How to modify the REST DestinationResource parameter dynamically at runtime
The DestinationResource parameter is available in the data flow properties list. Follow these steps to set up an expression:
- Create a variable that can be loaded with the desired name of the destination resource.
- Right-click on the data flow canvas and select the Properties menu.
- Scroll down and find the properties in the group called Misc.
- Note the name of the property you want to modify
dynamically at runtime. It will be named something like this: [REST
Destination].[DestinationResource]. This
is the property containing the destination resource.
- Scroll down and find
the Expressions property. Set up an expression for the property
noted above using a variable to modify it dynamically at runtime.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
REST Destination: How to modify the REST ExtendMetadata parameter dynamically at runtime
The ExtendMetadata parameter is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired custom metadata for the destination. Right-click on the data flow canvas and ...REST Destination: How to modify the [REST Destination].[Parameter] property dynamically at runtime
The [REST Destination].[Parameter] property is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired additional parameters for data insertion. Right-click on the ...Excel Destination: How to modify the Excel Destination worksheet name dynamically at runtime
The destination worksheet name is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination worksheet. Right-click on data flow canvas and ...SugarCRM Destination: How to modify a SugarCRM Destination module dynamically at runtime
The destination module is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination module. Right-click on data flow canvas and select ...Salesforce Destination: How to modify a Salesforce Destination object dynamically at runtime
The destination object is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination object. Right-click on data flow canvas and select ...