Post reply

Inserting Package Name Into Global Variable

  • August 12, 2003 at 1:47 pm

    #106925

    Can you put the name of a package into a global variable?

    Thanks

  • August 15, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • August 15, 2003 at 9:13 am

    #470121

    We use an ActiveX script task to set a global varible to the system date. Maybe you could set the package name this way too?

    Example

    '**********************************************************************

    ' Visual Basic ActiveX Script

    '************************************************************************

    Function Main()

    Main = DTSTaskExecResult_Success

    End Function

    DTSGlobalVariables("packagename").value = "test_package"

  • August 15, 2003 at 9:22 am

    #470124

    try in activex script

    DTSGlobalVariables("PackageName") = DTSGlobalVariables.parent.name

    But DTSGlobalVariables.parent.name will give you the package name in any part of the package without setting a global variable.

  • August 15, 2003 at 9:27 am

    #470125

    Thanks for the info, I'll give it a try

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

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