DB2 Destination: How to modify a DB2 destination table dynamically at runtime

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 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: [DB2 Destination].[DestinationTable]. This is the property containing the destination table.
  • Scroll down and find the Expressions property. Set up an expression for the parameter 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+.