Post reply

Setting Globals with T_SQL possible?

  • November 28, 2005 at 4:14 am

    #364330

    Currently I use ActiveX code to change the value of a GlobalVariable in an DTSpackage. Out of curiosity I wonder, if this can be done with T-SQL in an ExecuteSQL task? I am more home in T-SQL than VisualBasic.

    Greetz,
    Hans Brouwer

  • November 28, 2005 at 10:31 am

    #606162

    I don't think this is possible using and Execute SQL task.

    However you can set the global variable through T-SQL using a dynamic properties task.

  • November 28, 2005 at 11:47 pm

    #606321

    unfortunatly no. ( AFAIK)




    My Blog: http://dineshasanka.spaces.live.com/

  • November 29, 2005 at 1:48 am

    #606330

    If the value you want to set is the output of a stored proc, can't you just use an output parameter on the Execute SQL task? It's a while since I tried this so I could be wrong, but from addled memory I think the difficulty with these parameters is mapping the right variable to the right parameter.

    I think the ActiveX approach is rather easier to code and debug though.

    Bill.

  • November 29, 2005 at 2:06 am

    #606335

    Problem solved, tnx all. Never thought of the dynamic properties task...

    Tnx again.

    Greetz,
    Hans Brouwer

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply