File generation by SSIS in UTF-8 without signature with french characters

[AMalhotra]

I have a SSIS Package generating flat files. I need the file to be UTF-8 without Signature. I have tried various things. Under the FlatFileConnectionMgr I have set the code page to 65001 (UTF-8), I have tried setting AlwaysUseDefaultCodePage to true and code page to 65001 in Component Properties and under External Columns under Input and Output Properties.

If I set the properties to W_STR, the file generated shows it is UTF-8 file but french characters are distorted and when I use 65000 (UTF-8), french characters come through fine but the file generates as ANSI.

The consumer of the file has requested to generate a UTF-8 file (without signature) and obviously french characters need to be shown correctly in the file.

Does any one has any ideas on this?

 

[MakeItSo]

If you say "characters are distorted", do you mean corrupted to question marks or rather "ç" instead of ç?

If the latter, then the file _is_ properly encoded as UTF-8 and problem lies with how you check the generated file.

"Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.