1

I am trying to set up a simple KTR to copy over data from one table to another. In the target table, I have a column called JobId which is not mapped to anything in the source table (the idea is to capture the KTR job id in this column). I notice that if I do not include this column in the mapping, then the SQL generated drops the column from the table altogether (this happens irrespective of whether I set the update flag to Y or N), which is not what I want. I would like to know how to set the target column to a constant or not alter it altogether.

Thanks

Raam
  • 10,296
  • 3
  • 26
  • 27

1 Answers1

1

Use the add constants step, or the get variables step. In the get variables you can get the interal.transformation name variable if you like.

Codek
  • 5,114
  • 3
  • 24
  • 38