Im using the OLEDB Source to connect the source columns. But its throwing an error msg Column Name - cannot convert between unicode & nonunicode string data types. Could you please provide me the oracle code so that I can use with the select statement.
For some of the schemas I have chaged the data types using the derived column before the OLEDB destination.
Actually, one of my team member suggested me to use the Oracle char(2) in the select statement. Can any one help me with the code so that I can use it for the rest of the columns.
Eg source(External Column) - CreatedBYID - DT_wstr(18)
Source - Output cloumn - CreatedById - DTStr(18)
View Complete Post