Using Stored Procedure Return Value

#1

Hello all,

I have a stored procedure (syntax available on request) which counts the
number of records that fits a certain criteria. I would like to know if it
is possible that when this stored procedure is called during the execution of
a DTS package the "on faliure" would be tripped if the stored procedure
returns a value > 0 (i.e. there are records that match the criteria).

Does this make sense?

--
Thanks
Andrew

#2

You can certainly grab the output variable from the proc, test it and
then cause the flow to act a certain way.

Have a look here

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

"Whitless" <Whitless (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello all,

I have a stored procedure (syntax available on request) which counts the

number of records that fits a certain criteria. I would like to know if
it
is possible that when this stored procedure is called during the execution
of
a DTS package the "on faliure" would be tripped if the stored procedure
returns a value > 0 (i.e. there are records that match the criteria).

Does this make sense?

--
Thanks
Andrew

#3

Great stuff, as usual the answer is always there, I just needed to know what
to look for. Thanks fella

"Allan Mitchell" wrote:

Quote:

You can certainly grab the output variable from the proc, test it and
then cause the flow to act a certain way.

Have a look here

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

"Whitless" <Whitless (AT) discussions (DOT) microsoft.com> wrote in message
news:Whitless (AT) discussions (DOT) microsoft.com:
Hello all,

I have a stored procedure (syntax available on request) which counts the

number of records that fits a certain criteria. I would like to know if
it
is possible that when this stored procedure is called during the execution
of
a DTS package the "on faliure" would be tripped if the stored procedure
returns a value > 0 (i.e. there are records that match the criteria).

Does this make sense?

--
Thanks
Andrew

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using Stored Procedure Return Value

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using Stored Procedure Return Value - 02-02-2005 , 02:57 PM

Re: Using Stored Procedure Return Value - 02-02-2005 , 03:27 PM

Re: Using Stored Procedure Return Value - 02-02-2005 , 09:45 PM