DTS: Setting Global Variable using Stored Procedure Output parame

#1

Hi,
I'm trying to set a global variable with an output parameter defined as a
rowset value. The Global variable is declared as type 'string'. The output
variable in stored procedure is declared as varchar(200). However when I use
the global variable in an ActiveX script it is not set. Any ideas. I'm
doing exactly (I think) as the book states.

#2

Please do not post the same message under different subjects. I have
answered in your other post

--

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" <rob.beckman (AT) kroger (DOT) com (AT) discussions (DOT) microsoft.com>
wrote in message news:7A476ACF-3F3E-4100-898C-06309AE66F30 (AT) microsoft (DOT) com...

Quote:

Hi,
I'm trying to set a global variable with an output parameter defined as a
rowset value. The Global variable is declared as type 'string'. The
output
variable in stored procedure is declared as varchar(200). However when I
use
the global variable in an ActiveX script it is not set. Any ideas. I'm
doing exactly (I think) as the book states.

#3

Sorry,
But everytime I tried to post the question, microsoft website said it failed
due to system problem and did not realize that it posted it anyway.

"Allan Mitchell" wrote:

Quote:

Please do not post the same message under different subjects. I have
answered in your other post

--

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" <rob.beckman (AT) kroger (DOT) com (AT) discussions (DOT) microsoft.com
wrote

Hi,
I'm trying to set a global variable with an output parameter defined as a
rowset value. The Global variable is declared as type 'string'. The
output
variable in stored procedure is declared as varchar(200). However when I
use
the global variable in an ActiveX script it is not set. Any ideas. I'm
doing exactly (I think) as the book states.

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

DTS: Setting Global Variable using Stored Procedure Output parame

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

DTS: Setting Global Variable using Stored Procedure Output parame - 10-14-2004 , 10:27 AM

Re: Setting Global Variable using Stored Procedure Output parame - 10-14-2004 , 01:41 PM

Re: Setting Global Variable using Stored Procedure Output parame - 10-14-2004 , 02:49 PM