Null character type, either text or binary.

Character used to represent a null value. The null character can be any valid character in the file code page or any binary value from 0 to 255.

For source files, causes the Data Integration Service to read repeat null characters in a single field as one null value.

For target files, causes the Data Integration Service to write as many null characters as possible into the target field. If you do not enable this option, the Data Integration Service enters one null character at the beginning of the field to represent a null value.

Default is disabled.

Row at which the Data Integration Service starts importing data. Use this option to skip header rows.

Default is 1.

Number of bytes between the last column of one row and the first column of the next. The Data Integration Service skips the entered number of bytes at the end of each row to avoid reading carriage return characters or line feed characters.

Enter 1 for UNIX files and 2 for DOS files.

Default is 2.

Causes the Data Integration Service to read a line feed character or carriage return character in the last column as the end of the column. Select this option if the file uses line feeds or carriage returns to shorten the last column of each row.

Default is disabled.

Strips trailing blanks from string values.

Default is disabled.

Allows you to select the shift state for source columns in the Columns properties.

Select this option when the source file contains both multibyte and single-byte data, but does not contain shift-in and shift-out keys. If a multibyte file source does not contain shift keys, you must select a shift key for each column in the flat file data object. Select the shift key for each column to enable the Data Integration Service to read each character correctly.

Default is disabled.