as mentioned the flat file destination is a definition of what the file will look like. It does not offer any runtime configuration.

To do as you mention then you need to use a script task. as in that link.