I finally found the solution. While the "Editor" and "Advanced Editor" for the Flat File Destination do NOT have the ability to use an expression, it turns out that such an element is at a level where the Data Flow Task properties include that element, so it can have a property set there instead... Now I can have the current date be a part of the custom file header, while a Script Task takes care of adding the custom trailer.