How to modify query parameters dynamically at runtime
The source entity and query parameters are available in the data flow properties list. Follow these steps to setup expression:
- Right-click on data flow canvas and select Properties menu.
- Scroll-down and find property named like [Sage].[QueryParameters]. This is the property containing the query parameters.
- Scroll-down and find Expressions property. Setup expression to modify the criteria dynamically.
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
Dynamics CRM Source: How to modify the entity name dynamically at runtime
The entity's 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 entity’s name. Right-click on the data flow canvas and select the Properties menu. ...Dynamics CRM Source: How to modify the FetchXML statement dynamically at runtime
The FetchXML statement 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 FetchXML statement. (Example: vFetchXMLModifiedOnDate) Right-click on the data ...Dynamics CRM Destination: How to modify a Dynamics CRM destination entity dynamically at runtime
The destination entity 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 entity. Right-click on data flow canvas and select ...How to modify the source dynamically at runtime
The Object, ObjectFilter or Statement parameters are available for setup in the data flow properties list. Follow these steps to set up an expression: Right-click on the data flow canvas and select Properties from the menu. Scroll-down and find a ...How to modify source query dynamically at runtime
The source object, query and parent are available in the data flow properties list. Follow these steps to set up an expression: Right-click on the data flow canvas and select the Properties menu. Scroll down and find the property named like ...