ims.com


Trouble with Workflow 
Hello. I have a DTS package that executes some tasks of the type "Execute Package Task".
Every Task has a Condition of been executed just in case of success.  
I understand that only if the precedent task ends successfully the next one would be processed. My problem is that the DTS continues even if one of the previous steps fails. Would you have any idea 
____________________________________________________________________
My escenario is something like this:
EP: Execute Package Task 
ES: Execute Sql Task  

______                  _____ 
EP# 1      (on success)  ----> EP# 2        (on success)    ----> ....
______                        _____


So, EP#1 fails but EP2# is also executed.




Re: Trouble with Workflow DTS (SQL 2000)

Phil Brammer


SSIS or DTS

Are you sure EP#1 is really failing Do you have a success constraint set to a variable or some other value that always evaluates to true






Re: Trouble with Workflow DTS (SQL 2000)

mayraims

It is a DTS (Sql 2000) and have not defined any variable, i have just set the Workflow "On success" and it is between EP#1 y EP#2

EP#1 runs in another server. For example, it happens that the another server is offline and the package couldn't be executed, but anyway EP#2 continues...







Re: Trouble with Workflow DTS (SQL 2000)

Phil Brammer

You are in the wrong forum, for sure, but searching Google (*your* friend) returned several items related to your issue. Set the "Fail on first error" in the child package... Something like that. Take a look.

http://www.dbtalk.net/microsoft-public-sqlserver-dts/package-does-not-fail-even-162573.html





Re: Trouble with Workflow DTS (SQL 2000)

mayraims

Thank you Phil Brammer