Workflow Properties

  • Hi All, for documentation and debugging purposes, I'm looking for a way to enumerate the Name property found under Workflow Properties, Options tab, Name, for every object in my DTS packages. Thanks !

  • This property is just the name of each step (usually each step is associated with the task) of your package.

    You can write the activeX script which opens a package - then gets the step collections and collect names of each step from the collection and then write it to a text file.

    I have a script which does much more than that. I may put more details in the DTS Script modification trouble discussion thread if asked or I can get elaborate more on your particular problem.

    If you need more let me know.

    Tom

  • Thanks Tom, from your advice and other sources, I'm developing a script using SQL-DMO. I will let the forum know the results.

    Thanks again,

    Ignacio

  • Is it possible to change the Name property of an ActiveX Task from the ActiveX script?

    I need to change it for clarity purposes.

    cheers,

    Chin Mei

    Edited by - jmei on 01/10/2003 04:01:29 AM

  • Are you wanting to make a one-time change of the name of the ActiveX task? Or change it dynamically in the script itself? If a one-time change, simply double click the ActiveX task in the design window and, at the top of the ActiveX script window, highlight the name and type in the new name.

    Michael Weiss


    Michael Weiss

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

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