using vbscript in dts package

  • 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

  • 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

  • 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