To specify a static file name, in the

Target Object

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

Target Object

dialog box:

If you do not include a time stamp, the

mapping

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

mapping

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

mapping

task creates the target files MyTarget_15-01.csv and MyTarget_16-01.csv.