Post reply

Step at intersection of different paths in DTS does not execute

  • April 21, 2009 at 4:48 am

    #73606

    Hi,

    I have a simple scenario (shown in the attached file). Basically the execution path of my DTS reaches a point where based on the result of executing an ActiveX Script task ("Decision" task in the attached image) the execution will either continue down the "On Success" workflow path or the "On Failure" workflow path. Both paths meet in the same step ("Intersection Step" task in the attached image) that should be executed "On Success" of the last step in either one of the paths mentioned above. The problem I am facing is that this step at the intersection of the paths is never executed. I did a little more testing and it seems that it will only execute if both paths return a success simultaneously - which is not possible as I want the execution to conditionally branch down one of the paths.

    Can anyone shed some light on this problem?

    Thank you

  • April 21, 2009 at 10:05 am

    #981588

    Try changing both workflows leading to 'Intersection Step' to 'On Completion' rather than 'On Success'. Also, take a look at the method described in this article: http://www.sqldts.com/218.aspx.

    Greg

  • April 22, 2009 at 1:28 am

    #981976

    Hi Greg,

    Thank you for the response. Changing the paths to 'On Completion' did not help but the article you posted sure did.

    Thanks,

    Elias

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

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