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 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: [OpenAir Source].[Filter]. This is the property containing the filter.
- 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
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 ...OpenAir Source: How to modify the InputType parameter dynamically at runtime
The InputType 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 InputType. Right-click on the data flow canvas and select the Properties menu. ...OpenAir Destination: How to modify the OpenAir Destination type dynamically at runtime
The destination type 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 type. Right-click on the data flow canvas and select ...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. ...MongoDB Source: How to modify the filter property dynamically at runtime
The MongoDB filter property is available in the data flow properties list to be set dynamically at run time. Note: The process for setting the collection and samplesize properties for MongoDB are the same as for the filter property. Follow these ...