Post reply

Workflow stopped working in DTS Package

  • July 18, 2006 at 12:55 pm

    #67567

    Hi All

    I have chnaged the task names to some meaningful names in disconnected edit for a DTS package. After this, the workflow disappeared for this task w.r.t. other tasks. I have created again, but the subsequent tasks are not being executed in the event of failure/success.

    Any clue will be appreciated.

    Thanks

    Suresh

  • July 19, 2006 at 4:20 am

    #650043

    Within disconnected edit you will see tasks and steps.  Each step runs a task.  The steps may be running the old named tasks rather than the new.  You can also change the step names (this will change what you see in the output log files and the output from DTSrun).  If you do change the step names then you need to also change the precedent names, otherwise the step will again look for the old names.

    We standardly change the step and precedents (although it's often quicker to remove the workflow, change the step name and re-create the workflow).

    Look through these areas to check for anything which is pointing to an old name and change to something that exists now. If you need to delete something then changing the name will allow it to show on the diagram so that you can delete it from the display.

  • July 19, 2006 at 6:44 am

    #650081

    Thanks for the reply..

    The issue was resolved. The procedue for changing the names in disconnected mode is -

    Remove workflow

    Rename the tasks

    Redo the workflow.

    After this, the workflow worked.

    --Suresh

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

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