Post reply

using vbscript in dts package

  • February 12, 2002 at 3:39 pm

    #104772

    i am writing vbscript in my activeX component. I need to refer to the name of the entire dts package and use it as a variable. My question is how can I retrieve the actual name of the package in vbscript?

    liz

    Elizabeth


    Elizabeth

  • February 13, 2002 at 1:22 am

    #423744

    Hi Liz,

    One can use : DTSGlobalVariables.Parent.Name in VBScript to get the Package Name

    This package object (DTSGlobalVariables.Parent...) can also be used to reference the DTS Package's Tasks, Connections, Steps, Transformations, etc.

    Hope it helps.

    Dirk

  • February 13, 2002 at 7:18 am

    #423757

    perfect! Thanks

    Elizabeth

    Elizabeth


    Elizabeth

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy