DTS global variable question

Hello,
I am having difficulty with global variables in DTS. Specifically
I would like to instantiate a global variable with a value obtained
from a SQL database. I have created the global variable through the
package properties section. Now i need to instantiate it with a value
from the database. Should i use an ActiveX Script Task to accomplish
this? If so can someone send me a link that shows the best way of
doing this?

Thanks,
BillyAn ActiveX script task will do the job but you could also use a
DynamicProperties task if you are using SQL 2000. This enables you to set
properties at run time without writing code.

See http://www.sqldts.com/default.aspx?205 for an ActiveX script for an
example as sell as other useful DTS info.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Billy Cormic" <billy_cormic@.hotmail.com> wrote in message
news:dd2f7565.0409261325.4dda82fd@.posting.google.c om...
> Hello,
> I am having difficulty with global variables in DTS. Specifically
> I would like to instantiate a global variable with a value obtained
> from a SQL database. I have created the global variable through the
> package properties section. Now i need to instantiate it with a value
> from the database. Should i use an ActiveX Script Task to accomplish
> this? If so can someone send me a link that shows the best way of
> doing this?
> Thanks,
> Billy