Post reply

How do I set the ExecutePackageTask.FileName property using ActiveX Script Tasks?

  • September 23, 2004 at 4:02 am

    #162220

    Hello,

    How do you get and set the FileName property of an ExecutePackageTask object?

    I tried doing something like this:

    Dim objConn1

    Set objConn1 = DTSGlobalVariables("<ExecutePackageTask_ObjectName>")

    objConn1.FileName = "C:\SomePackage.dts"

    but obviously it doesn't work (or else I wouldn't be posting this question hehe)

    Thanks so much!

    -Rafferty

  • September 23, 2004 at 4:17 am

    #524126

    You need to create a reference to the task object first.

    Eg: Set objTask = DTSGlobalVariables.Parent.Tasks("Exec Package Name")

    objTask.Filename = "filename"

    Or you can use a Dynamic Properties task.

    --------------------
    Colt 45 - the original point and click interface

  • September 23, 2004 at 7:04 pm

    #524278

    wow! haha thanks a lot! I tried doing this already but I found out that it cannot detect the Exec Package Name I specified. Is the exec package name, the description of the ExecutePackageTask object? or is it the name specified when I look at the workflow properties (under the options tab)?

    It doesn't seem to work for both...

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

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