Write File Transformation Properties
Use this dialog box to copy the contents of a source column (data column) to a file whose path is specified by a second source column (file name column).
Options
Directory
Type the directory in which the files specified in the file name column are located or browse for the directory. At run time, each of the entries in the file name column is appended to this directory name to create a save path. If no file exists at that location, one is created and initialized with the contents of the data column.
File type
Select whether the files to which the transformation writes data are ANSI, Unicode, or OEM.
File name column
Select the column containing the list of file names from the list.
Handle existing file
Select an option for situations where the file in which to write data already exists.
- Overwrite if file exists
- Replace the contents of the existing file with new content (default selection).
- Append if file exists
- Retain the existing content of the file and add the new content to the end of the file.
- Error if file exists
- Terminate processing and fail the write file transformation if the file exists.