I faced an error: 'SSIS cannot convert between unicode and non-unicode string data types' even though the source and the destination columns are both unicode (NVARCHAR) data type. The source db and the destination db are on the same server.
The source is a query:
SELECT CASE WHEN [Gender__c] = 'Female' THEN 'N' WHEN [Gender__c] = 'Male' THEN 'M' WHEN [Gender__c] = 'Nainen' THEN 'N' WHEN [Gender__c] = 'Mies' THEN 'M' When [Gender__c] = 'Ei tiedossa' THEN 'Ei tiedossa' ELSE NULL END as Gender__c FROM [database].[table]
Anybody seen the same?