How to modify the source dynamically at runtime
The source list or query 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 [SharePoint Source].[InputList]. This is the property containing the input SharePoint list.
- Scroll down and find the property named like [SharePoint Source].[InputQuery]. This is the property containing the CAML query.
- Scroll-down and find the Expressions property. Set up an expression to modify the above properties 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
SharePoint Destination: How to modify the SharePoint Destination list dynamically at runtime
The SharePoint destination list 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 list. Right-click on the data flow canvas and ...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 ...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. ...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 ...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 ...