JSON Source: How to modify the Json File's name dynamically at runtime
The JSon file's name is available in the data flow properties list. Follow these steps to set up an SSIS+ expression:
- Create a variable that can be loaded with the desired JSon file's name.
- 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: [JSon Source].[JsonFile]. This is the property containing the JSon file's name. Please look at the screenshot below:
- 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
Related Articles
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 ...LDAP Source: How to modify the filter dynamically at runtime
The filter 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 filter. Right-click on the data flow canvas and select the Properties menu. Scroll ...Excel Source Plus: How to modify the worksheet name dynamically at runtime
The source 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 worksheet name. Right-click on the data flow canvas and select ...OpenAir Source: How to modify the Filter parameter dynamically at runtime
The Filter 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 filter. Right-click on the data flow canvas and select the Properties menu. Scroll ...Dynamics AX Source: How to modify the statement parameter dynamically at runtime
The statement 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 statement. Right-click on the data flow canvas and select the Properties menu. ...