SP2 Issue With Execute SQL Parametrized Query

Hello,

I try SP2 and cannot get the Execute SQL task to work as before.

In this example I use an OLEDB Microsoft Oracle provider.

The script uses a parameter like that

 select Cast( decode((
select
DECODE(TRUNC(c.END_DATE), TRUNC(SYSDATE),1,NULL) AS RESULT
from one_stage.load_complete c
where TRUNC(c.end_date) = TRUNC(sysdate)
and c.name = ?
and c.STATUS = 'SUCCEEDED')
,Null,0,1)  as varchar(2)) AS Result from Dual

The script task is set to BypassPrepare = False

I note only one change, the addition of a parameter setting called Parameter Size set by default to -1

I tried different things like reading the new BOL, changing the Bypass prepare, Changing the Parameter Size and changing the ? , nothing works. the output variable is always set to a value of 0 which is the result of the query test if there is no match.

It looks like the input variable is no longer passed to the query parameter.

What should I do to get this to work with SP2?

Thanks

Philippe