June 5, 2014 at 10:12 am
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?
Thanks.
June 5, 2014 at 11:28 am
Hi Jose,
Bit of a known issue. Seems the best work around is to create two copies of your template and then file copy the empty one to the directory and 'always' use append.
For a solid explanation of what's happening, scroll to the bottom of this thread.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply