lindss01
SSCrazy
Points: 2264
More actions
August 24, 2005 at 7:36 am
#66686
In an Execute SQL Task how does one set the the condition so that the failure path is taken. I am doing some error recovery. So if the file I am processing has already been processed then I want to go down the failure path.
Steve
Bimal Fernando
SSCommitted
Points: 1945
August 25, 2005 at 12:51 am
#584872
Raise an error in the SQL Query Task like below..
RAISERROR ('Error Occured',16, 1)
and it'll follow the failure path.
August 25, 2005 at 6:01 am
#584920
Thanks that'll do it!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply