Write File Transformation Properties

DTS Designer

DTS Designer Help

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.

See Also

Write File Transformation