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 property.
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.
- 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: [Salesforce].[Statement]. This is the property containing the Statement name
- 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
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 ...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. ...LDAP Source: How to modify the source object dynamically at runtime
The source object 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 object name. Right-click on the data flow canvas and select ...NetSuite Source: How to modify the SearchXML statement dynamically at runtime
The SearchXML 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 SearchXML statement. Right-click on the data flow canvas and select ...Dynamics GP Source: How to modify source object criteria dynamically at runtime
The source object criteria are 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 ObjectCriteriaXML. Right-click on the data flow canvas and select ...