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.