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 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: [MongoDB Source].[Filter]. This is the property containing the filter’s 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
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 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 ...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 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 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. ...