Is there a way to force a DTS step to fail using a SQL statement, keyword, etc.?
I have a stored proc. that returns codes based, including any SQL error codes that may occur. Within the DTS step I would like to use something like:
If @iVal <> 0
Begin
<< force error >>>
End