> Can anyone tell me how to access DTS properties (such as global
> variable values) via TSQL?
>
> Examples would be nice.
>
> Thanks
>

Simon Sabin wrote:
> Hello BLS,
>
> DTS doesn't run within TSQL. Are you trying to execute some TSQL from within
> a DTS package and have the TSQL use some global variable.
>
> If so you can set the SQL in your execute sql task from an activex script
> component. In here you can build the TSQL with the value of the global variable.
>
>

Allan Mitchell wrote:
> Using the ExecuteSQL task you can assign values from a SQL Statement to
> Global Variables.
>
> Is this what you want?

"BLS" <bigluckysmile@gmail.com> wrote in message
news:1167685792.984682.111360@n51g2000cwc.googlegroups.com:

> Simon Sabin wrote:
> > Hello BLS,
> >
> > DTS doesn't run within TSQL. Are you trying to execute some TSQL from within
> > a DTS package and have the TSQL use some global variable.
> >
> > If so you can set the SQL in your execute sql task from an activex script
> > component. In here you can build the TSQL with the value of the global variable.
> >
> >
>
> What I would like to do is access a DTS global variable inside a TSQL
> task. I'd like to set its value, etc, only not via activex but using
> TSQL.