How to modify the source dynamically at runtime
The Table 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 the Properties menu.
- Scroll down and find the property named like [Teradata Source].[Table]. This is the property containing the source table.
- Scroll down and find the Expressions property. Set up an expression to modify the table 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
Teradata Destination: How to modify the Teradata Destination table dynamically at runtime
The destination table 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 table. Right-click on the 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 ...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 ...