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 property named like [Salesforce Source].[Statement]. This is the property containing the statement.
- Scroll-down and find the Expressions property. Set up an expression to modify the statement 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 ...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 ...Salesforce Source: How to modify SOQL Statement property dynamically at runtime from SSIS Expression
The Salesforce SOQL Statement property is available in the data flow properties list to be set dynamically at run time. Note: The process for setting the BatchSize, Object and ObjectFilter properties for Salesforce are the same as for the Statement ...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 ...