SSIS stored procedure return value

#1

I'm trying to get the return value from a stored procedure in a SSIS
execute sql task.
The SP is just a return 1 at the moment, and I can't figure out how to
get that value and put it into a user variable.

Any suggestions?

#2

Hello Ayende (AT) ayende (DOT) com,

This article may be able to help you.

The ExecuteSQL Task
(http://www.sqlis.com/default.aspx?58)

There is an issue at the moment that I am trying to narrow down. it is not
in the article but it is in the task itself.

Allan

Quote:

I'm trying to get the return value from a stored procedure in a SSIS
execute sql task.
The SP is just a return 1 at the moment, and I can't figure out how to
get that value and put it into a user variable.
Any suggestions?

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

SSIS stored procedure return value

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

SSIS stored procedure return value - 01-12-2006 , 04:05 AM

Re: SSIS stored procedure return value - 01-14-2006 , 07:45 AM