DSXchange

If you first obtain the month, then you can use the following expresion to get the last day of the month:

OConv(MONTH.LAST(MES),'D-YMD[4,2,2]')

being the format of variable MES the following: YYYY-MM

Yes the service name is available

the TNSNAMES is also in the correct place and readable

The Oracle client work perfectly, I can connect with SqlPlus. But where is th dsenv file?

yes, it is works

but if after do that, after the first step I need to go through an aggregator stage, so I can group by all the cantities (BALANCE_AS.CAN_EXTRACCION), and after that I have to multily the result. In this step I have new problems, if I try to do it in a transformer stage, again, there is not links bet...

Thank you, finally it worked

Raquel