How to modify a destination table dynamically at runtime.
The destination table is available in the data flow properties list. Follow these steps to set up an expression:
- Right-click on data flow canvas and then select the Properties menu.
- Scroll down and find the property named like [DB2 Destination].[DestinationTable]. This is the property containing the destination table.
- 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
Informix Destination: How to modify the Informix 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 ...Dynamics AX Destination: How to modify the Dynamics AX 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 data flow canvas and select ...Oracle Destination: How to modify the Oracle 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 ...DB2 Destination: How to modify a DB2 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 data flow canvas and select ...ODBC Destination: How to modify the ODBC 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 ...