DTS Ouptut parameter prob

[whool]

SQL 2000,

I am trying to pass an Output param from a Stored Proc
(using Exec SQL Task) to a DTS global variable.

This is the SQL task:

declare @retval int
execute @retval = dbo.usp_test
select @retval as rv

I am able to map the parameter to a Global variable and the SQL task works OK but when I try to return it though an ActiveX script, the value has not been passed.

This is very puzzeling because:

1. I have run the same SQL script from Query analyser and
a get a value for the parmater.

2. The parmeter DOES get ruterned to the ActiveX task if I use the following Exec SQL task to poplulate it:

declare @rv int
set @rv = 102
select rv = @rv


I seems that the Exec SQL task is not capable of processing returned values from SPs.

Can anybody shed any light.

Cheers,

yael