• Hello Ed Wagner and really thanks for any help!

    The problem is that i am using the sql server 2012 Attunity service and i cant do any select on the source or destination. But I can define the type that the destination column will have. So i tried nvarchar and varchar and you can see the rusults... Using a ssis to transfer tha data there is not a probleme and without using a transform task. See what I have noticed... The ssis creates the column types varchar2 on the source as nvarch types on the destination. But using another oracle instance with the same schema|database it crates the destination columns as varchar. The difference between them is that the first has national encondin as 32utf16 and the second utf8... i must try this service with the second instance.

    Uff! Wish me good luck!!

    Rena