How to enable SSIS package ETL to import French characters into SQL Server

I got an email from one of workmate to show me that the french characters are valid in the CSV file.

However those customer anmes with French accents had been screwed up with one example

the name is ANDRÉ in the  CSV file. the user queried the database but return
ANDRÉ 


the root cause of this issue stems from the character set in the connection string configuration.

you can view my previous posting about the character set setting in the connection string

how-to-import-unicode-characters-from Excel to SQL

I can quickly fix the package to support the french accents in the customer name by setting
the code page to be 65001(UTF-8)