DTS and Variable Help Needed

[ehague]

I am working on a project that is transfering data beween an AS400 and a flat file using SQL 2000 DTS. The company wants me to set up variables so that the servername and database name can be changed within the DTS package. This way they can use one DTS package for several different servers and databases. I have been doing some reading and I believe that the way to do this is to set up global variables and create an ActiveX Stripting task. How do I get the Execute SQL Task to see the global variable? Can someone please walk me through the steps of how to set this up?

Thanks-

Elizabeth