sql server dts: Workflow: Failure Step -- sql server dts

Workflow: Failure Step

Stephen Costanzo
8/25/2005 1:10:27 PM

sql server dts:

I have a simple workflow that executes three tasks and in the final task I
have a success branch and a failure branch.

The final task is a sql statement to delete rows in the table. I
intentionally misspelled the column name and saved the package. My thought
was it would go to the failure step. Is this not correct? Or will the
failure only occur if, perhaps, I cannot delete the rows from the database?

Thanks in advance

Re: Workflow: Failure Step

Allan Mitchell
8/27/2005 9:08:29 AM

You have a success branch and a failure branch going to the same task or
going from the task?

If you have a spelling mistake for example

select kk from dbo.authors

and then have an "On Success" branch and an "On Failure" branch from the
task then the task will fail and the "On Failure" branch will be followed

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)

Allan

[quoted text, click to view]