OK. If you put a data viewer right before you write to the destination, does the data look normal?
When the flat file is created, can you double check the encoding using a decent text editor, like notepad++?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP