i am executing

Following

DECLARE @res int
EXEC @res=Exec Admin_Fixes_Process_Duplicates_Referrals
SELECT @res

in Execute SQL Task

My question, If @res value is not equal to 0 i have to make
task failure else goto next task

can any one give idea how to solve my problem,

Kalyan,


SELECT @res into a column alias.. For example

SELECT @res as ResultCode

Next, click on the parameter button. Click on the Output Parameter tab
followed by the Row Value and you should see ResultCode. From there you can
assign the ResultCode to a Global Variable. Next using ActiveX Script , you
can read in the global variable and set the Workflow Success or Failure flag
based on the value in the REsultCode.
"Kalyan" wrote:

Or maybe fail the task with raiserror?

if @res <> 0
raiserror(blah blah)


In message <1803284C-D1C8-40C9-90A1-38AF5BEA0973 (AT) microsoft (DOT) com>, Rodney
Mullins <Rodney (AT) Mullins (DOT) ?.microsoft.com.invalid> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org