Thanks..yes I removed group by and it works fine now.

Thanks again

Hi Mahesh,

Thanks for reply.

I tried with that.

Now it gives me this errro.

Invalid column name 'SOURCE_SYS'.

If I remove whole GROUP BY expression, then It works fine. But I can not see...

I have the same problem..I want to convert data from string to int...three columns of my table contain single letters(String datya type). Before i load them into destination TABLE, I want to convert...