Scope of DTS Global Variable and DTSRUN
Posted on 2006-07-08
I have created a DTS Package with 2 Global Variables (gvInput & gvOutput) (defined in design mode i.e. using Package Properties). On execution of the DTS Package the execution result is stored in gvOutput.
If I execute the package in DTS Designer everything works perfect and gvOutput retains the value, even after closing and reopening EM.
But, if I execute the package through DTSRUN command line utility, everything works perfect, but the values are not retained.
I hope most of the experts might have faced this.
Thanks in advance ;-)