Error 0x00470d4: Data Flow Task 1: The code page on input column “COLUMN_NAME” (111) is 1252 and is required to be 65001.
(SQL Server Import and Export Wizard)

Usually this error appears when the table has a data type of VARCHAR, what you need to do is to change it NVARCHAR.