cannot convert between unicode and non-unicode data types error using SSIS to move data from SQL Server to oracle
Posted on 2008-10-27
i'm trying to move data from SQL server 2005 to oracle 10g, i keep recieving the error message
cannot convert between unicode and non-unicode data types ,
the data type of the columns in error is nvarchar in SQL Server DB(Source DB), and its varchar2 in the oracle DB(Destination DB),i created a data conversion task between the source and destination and tried choosing DT_STR and DT_WSTR but that didnt help! still the same error message, should i choose a different data type, is there something else i need to do?
appreciate any suggestions :)