Post reply

Accessing DTS Constants from VBScript not running with DTS

  • September 30, 2005 at 9:14 am

    #66908

    I am writing a Windows Script Component File that will wrapper up some common code that I want to execute from more than one DTS package.

    I can then treat the file as a COM object.

    I want to access the DTSStepPrecedenceBasis constant values e.g.DTSStepPrecedenceBasis_ExecStatus

    As my .wsc component is not running under DTS my script has no visibility to these.

    Does anyone know how to get hold of these from a script that is not an ActiveX script within DTS?

    For obvious reasons I do not want to declare the values locally.

     

  • October 3, 2005 at 5:18 am

    #594512

    If I am understanding your question correctly, I believe you would have to create an object within your component to DTS.Package2 then access the value of the constants via the object hierarchy.

    You can only access the internal constants of the DTS objects if you have a refference to it.

    -Mike Gercevich

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

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