Common SSIS ETL issues

Message: Cannot convert between unicode and non-unicode string data types: This happens when we want to insert unicode (such as MySQL varchar with latin_swedish collation) data into a non-unicode (such as . Or a non-unicode (such as MySQL varchar with utf8 collation) into a unicode field (such as SQL Server Nvarchar or Nchar). The problem[…]