utf 8 - SSIS export data as UTF-8 csv file without BOM

Question

I have created an SSI Package that queries a database table and exports the results as a .csv file. I have noticed that the file generated is USC-2 LE BOM how do I create a UTF-8 csv file without BOM? my flat file connection manager code page is set to 1252 ANSI, i have also tried checking the 'unicode' option within the connection manager but this does not help. any guidance would be appreciated

question from:https://stackoverflow.com/questions/65937031/ssis-export-data-as-utf-8-csv-file-without-bom

Answer 1

Waitting for answers