Hi,

I'm using SSIS on SQL2005 XP2.

I've got an Oracle OLEDB connection.

I've got a simple SQL Task on my Oracle DB (returning one field in one
row), and I try to send the result to a local variable

select 'aaa' from dual --> I can send the result in a 'STRING'
variable
select 1 from dual --> impossible to send it to any SSIS type !


Is it really impossible to get this value in my sql task ?