Execute SQL Task -- not setting Output parameter

#1

I've read and followed the article http://www.sqldts.com/default.aspx?234 but
I _still_ can't get the result from the stored procedure's output parameter
to populate my DTSGlobalVariable -- and it's driving me nuts! I 've tested
the stored procedure in Query Analyzer and it's working correctly. Any
suggestions?

Execute SQL Task code is:
------------------------------
declare @Ready tinyint
exec LoadGroup_IsReadyToLoad ?, @Ready output
select @Ready as Ready

#2

Have you tried SET NOCOUNT ON?

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

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

Quote:

I've read and followed the article http://www.sqldts.com/default.aspx?234
but
I _still_ can't get the result from the stored procedure's output
parameter
to populate my DTSGlobalVariable -- and it's driving me nuts! I 've tested
the stored procedure in Query Analyzer and it's working correctly. Any
suggestions?

Execute SQL Task code is:
------------------------------
declare @Ready tinyint
exec LoadGroup_IsReadyToLoad ?, @Ready output
select @Ready as Ready

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

Execute SQL Task -- not setting Output parameter

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

Execute SQL Task -- not setting Output parameter - 03-03-2005 , 03:49 PM

Re: Execute SQL Task -- not setting Output parameter - 03-04-2005 , 04:03 AM