Session Variables not getting set using SETMAXVARIABLE, SETMINVARIABLE,SETVARIABLE,SETCOUNTVARIABLE

Make sure the Port is Variable Port.


Make sure in Transformation where you have set the variable, the port should be a Variable Port.
If you don't check it as variable port the Session variables values will not persist.

1 comment:

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...