Issue : This error come before when migrate data from oracle to SQL server using SSIS ?
Error Column "Col1" cannot convert between unicode and non-unicode string data types
Solution:
The column is coming back as unicode and then either being loaded into a non-unicode (varchar) column in the table, or possibly set to output as non-unicode in the oracle source (or non-unicode to unicode). Try putting a data conversion component in the data flow between the source and destination, and set data_1 column to match the type and width of the target table/column.
Error Column "Col1" cannot convert between unicode and non-unicode string data types
Solution:
The column is coming back as unicode and then either being loaded into a non-unicode (varchar) column in the table, or possibly set to output as non-unicode in the oracle source (or non-unicode to unicode). Try putting a data conversion component in the data flow between the source and destination, and set data_1 column to match the type and width of the target table/column.
Comments
Post a Comment
Please avoid link comments