I am trying to set the value global variable in a DTS SQL task to be used by a Active X script task within the same DTS. This works fine when I run the DTS through enterprise manager but when I run the DTS through SQL Server Agent it doesn't seem to update the value of the global variable! The server is running SQL 7 SP3.

Does anyone know how to get around this problem?


Michael Young