How to modify the source dynamically at runtime
The source “module”, “query” and “order by” parameters 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 [SugarCRM Source].[Module]. This is the property containing the module.
- Scroll down and find the Expressions property. Set up an expression to modify the module 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
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 ...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 ...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 ...