CSV destination UTF8 encoding

[mossbs]

(this is a repost from the SSIS forum as this area seems to get more hits... apologies for duplication!)

Hi guys - having massive issue trying to get SSIS package to export data to a csv file with UTF8 encoding.

I've tried a number of things... and lateset package consists of the following..

- File system task
- this has a source of a csv template (in UTF8) and a destination created from an expression to append the date to the end of the file

- Data Flow Task
- This has DB source, data conversion task and flat file destination.
- in the data conversion I convert all columns to UTF8

But when I run it - and then open it the file is saved with ANSI encoding.

Any ideas where I am going wrong?

Cheers guys!