FreeHansje
SSChampion
Points: 11751
More actions
August 3, 2004 at 5:22 am
#59965
Hi there,
In a ExecuteSQL task I'm reading a record in a table. If it's there, follow succes else force the failure arrow.
How can I do that? I guess I could use a VBtask instead of ExecuteSQL, but how do I do handle it there?
Greetz,Hans Brouwer
David Burrows
SSC Guru
Points: 65144
August 3, 2004 at 7:13 am
#517428
In ExecuteSQL task, RAISERROR will cause the 'On Failure' workflow to trigger. eg
IF NOT EXISTS (SELECT 1 FROM [sometable] WHERE [sometest])
RAISERROR 'Record Does Not Exist',16,1
Far away is close at hand in the images of elsewhere.Anon.
August 3, 2004 at 7:34 am
#517437
Tnx Dave, this'll work.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply