Post reply

Globe Code in DTS VBScript

  • February 23, 2004 at 8:32 am

    #59651

    Can SQL Server 2000 DTS Package Handle Globel Code Functions?

  • February 24, 2004 at 12:16 am

    #495245

    I don't know any way to use Global functions in a DTS Package . Instead you can use a Public function within an activeX script.

     

     

  • February 24, 2004 at 5:12 am

    #495274

    How do i call a public function

  • February 24, 2004 at 5:27 am

    #495281

    Functions are treated as in VB. You can have as many function as you like within an ActiveX script BUT you cannot use ANY of them in another ActiveX script inside you package. the same applies to the ActiveX script a task might have. Try it.

    Function Main()

      call DisplayMsgBox("This is a test")   

    end Function

    Function DisplayMsgBox(MyMessage)

       msgbox MyMessage

    end function

    Dimitris

    ....

     

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

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