Hi,

I want to populate a global variable in a DTS package. Unfortunately, SQL 7 does not have the Dyncmic Properties option available, SQL 2000 has this option.

I am unsure on how to perform this task using Active Scripting.
Would someone please show me an example of how I can populate a Global Variable in DTS using with a SQL query.

Thanks for your help.

Alvin