HI,
Trying to set a Global Variable using output from a stored procedure. I'm
using a row value. The stored procedure variable is declared as
varchar(200). The Global Variable is declared as type string. However, when
I display the global variable from an ActiveX script the global variable is
NOT set. Any ideas

Have a read through this article.

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"rob.beckman (AT) kroger (DOT) com" <robbeckmankrogercom (AT) discussions (DOT) microsoft.com>
wrote in message news:7E88BD68-A657-4938-B613-8F50614AC5CC (AT) microsoft (DOT) com...

I have it working. The problem is that I was using Raiserror and then
returning a message variable back to the DTS. The Raiserror keeps the output
paramater from being mapped to the global variable. So I tried to check the
return code from the stored procedure and if the return code = 1, I want to
issue an raiserror so the DTS takes a different branch. However, it never
executes the raiserror after mapping the global variable. Sounds like a BUG!

"Allan Mitchell" wrote: