Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS not updating global variable ?

Status
Not open for further replies.

rabinski

Programmer
May 13, 2005
21
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top