In SQL Server 2000, in DTS, a SQL Query Task executes a stored procedure that returns 0 or -1. Either value causes a Workflow property of success, but I require two different actions. I do not want to cause the package to fail (for example with raiseerror). I can conditionally check the return of the stored procedure and need to know what to set in order to have the DTS workflow properties of success and failure lead to the next steps.
