Model Properties Data Movement Tab

The model properties sheet Data Movement tab contains properties to control the files used during data movement.

Property

Description

Field delimiter

Specifies the delimiter to be used between fields in the dump file.

Row delimiter

Specifies the delimiter to be used between rows in the dump file.

Fully delimited file

Specifies that each row ends with a field delimiter before the row delimiter.

Maximum image or text size

Specifies the maximum length of an image (or text) record, to which it will be truncated if necessary.

Load file directory

Specifies the directory where the load file is located.