Hi gurus -
I have a DTS that just does a count on a table , writes the info to a txt file and should then increment the global variable using this
' increment the Global Variable (BatchNumber)
DTSGlobalVariables("BatchNumber").value = iBatchNumber + 1
it works fine when I run the step manually - but using a scheduled job it all runs fine apart from the actual increment ...
Any ideas would be most excellent ...
thanks in advance
Rab
I have a DTS that just does a count on a table , writes the info to a txt file and should then increment the global variable using this
' increment the Global Variable (BatchNumber)
DTSGlobalVariables("BatchNumber").value = iBatchNumber + 1
it works fine when I run the step manually - but using a scheduled job it all runs fine apart from the actual increment ...
Any ideas would be most excellent ...
thanks in advance
Rab