If you create a flat file target at run time, you can specify a static file name. The file name can include a time stamp that indicates when the file was created.
To specify a static file name, in the
dialog box, enter the file name in the
Static File Name
field. To include a time stamp, enable
Handle Special Characters
and add the time stamp characters to the file name. For example, the file name MyTarget_%d-%m.csv includes the day and month in which the mapping ran.
The following image shows the
If you do not include a time stamp, the
task creates the target file the first time the task runs and overwrites the file during subsequent runs.
If you append a time stamp to the target file name, the
task writes data to a new file when the time stamp changes. For example, you enable special character handling, enter static file name MyTarget_%d-%m.csv, and run the mapping task on January 15 and January 16. The
task creates the target files MyTarget_15-01.csv and MyTarget_16-01.csv.