I have a package that produces a text file based on a text file template which is saved as a UTF-8 file. I do this so that the actual file created is also created as a UTF-8 file. The problem is that if you turn on the overwrite option in the properties of the flat file connector, the file created is saved as ANSI instead of UTF-8. The only way I know to avoid this is to have the overwrite option turned off, but that presents a different challenge which is data getting appended to the destination file that should not be there. Does anyone have thoughts/suggestions on how to best tackle this issue?