Hi all,
I have a DTS package where an SQL task that simply selects * From table
where something = something. If this statement does return a value go to
next step as success workflow. If the select statement does not return any
results then I want the package to run the nextstep as failure workflow. For
some reason, the task simply stop. Here is my SQL task statement

if exists(select count(1) from table where uniquekey=114467 having
count(1)>0)
update table
else
raiserror ('task failed', 16,1)

Thanks!