PutJatDa-302517
Mr or Mrs. 500
Points: 545
More actions
June 2, 2006 at 8:04 am
#91956
In a DTS package, I have various SQL tasks which are linked by workflows, either 'on success' or 'on failure'.
What is the sql statement for making a sql task fail so that it follows the 'on failure' workflow?
Thanks
PW-201837
SSC-Insane
Points: 20805
June 2, 2006 at 8:57 am
#641467
Many options to choose from. Divide by zero should do it:
SELECT 1 / 0
Carl Federl
One Orange Chip
Points: 25384
June 10, 2006 at 5:37 am
#642963
RAISERROR with a severity of 16
SQL = Scarcely Qualifies as a Language
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply