Read File Transformation Properties

DTS Designer

DTS Designer Help

Read File Transformation Properties

Use this dialog box to copy the entire content of a file specified by a source column to a destination column.

Options

Directory

Type the directory location for the files from which you want to read data. At run time, each of the entries in the source column is appended to this directory name to form a read path. If a file exists at that location, it is opened and the contents (possibly translated) are copied to the destination column. The directory name may start with a disk drive or a Universal Naming Convention (UNC).

You also can browse for the location of the directory containing the files from which you want to read data.

File type

Select whether the files that the transformation reads data from are ANSI, Unicode, or OEM.

Error if file not found

Select to stop processing and fail the read file transformation if a file specified in the source column is not found in the directory location.

See Also

Read File Transformation