Re: Output Parameters set by Stored procedure
rob.beckman_at_kroger.com
Date: 10/14/04
- Next message: Josh: "Re: Help with XP-SP2 issues"
- Previous message: Allan Mitchell: "Re: Execute SQL Task oddity"
- In reply to: Allan Mitchell: "Re: Output Parameters set by Stored procedure"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 14 Oct 2004 12:55:03 -0700
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:
> 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@kroger.com" <robbeckmankrogercom@discussions.microsoft.com>
> wrote in message news:7E88BD68-A657-4938-B613-8F50614AC5CC@microsoft.com...
> > 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
>
>
>
- Next message: Josh: "Re: Help with XP-SP2 issues"
- Previous message: Allan Mitchell: "Re: Execute SQL Task oddity"
- In reply to: Allan Mitchell: "Re: Output Parameters set by Stored procedure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
