Columns

List of Fixed Width Column

Yes

Contains definitions of columns which will be read from the input file.

Data Format Parameters

Data Format Parameters

Yes

Contains data formatting information for the whole step. For details refer to the DataFormatParamaters section.

Encoding

String

Yes

Specifies encoding used in the input file.

Error Handling Strategy

Error Handling Strategy

Yes

Definitions of error state management. Defines how to handle each error which can occur during processing. For a detailed description of error strategies see Error Handling Strategies.

File Name

String

Yes

Name of the input file to process.

Ignored Row Reg Ex

String

No

A regular expression that is compared to lines in the input file. If a line (read as a string) matches the regular expression, the line will be ignored.

Number Of Lines In Header

Integer

Yes

Specifies the number of lines from the beginning of the file that will be excluded from processing (header lines, comments, etc).

Number Of Lines In Footer

Integer

Yes

Specifies the number of lines from the end of the file that will be excluded from processing (footer lines).

Line Max Read Length

Integer

Yes

Specifies the maximum number of characters per line to be read and processed. If the length of the line exceeds this value, an error occurs.

Line Separator

String

No

Specifies the string to be recognized as a line delimiter. The line delimiter can be any sequence of letters, although a specific symbol is often used which usually depends on the operating system where the file originated from. The special symbols are: \r = CR, \l = LF, \n = LF. This parameter is not needed for files with a fixed line length.

Shadow Columns

List of Shadow Column Def

No

Contains a set of columns that are not present in the input data, but should be created in the output (so that they are then available for further use as any other "real" column read from a file).

Id

String

No

Step identification string.