Skip to main content

Posts

Showing posts with the label data conversion component in the data flow

SQL SSIS Error Column "Col1" cannot convert between unicode and non-unicode string data types

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.