Property | Description |
|---|---|
Flat File Type | File type, either delimited or fixed-width. |
Delimiter | Delimiter character for delimited files. |
Treat multiple characters as a single delimiter | Treats the specified set of delimiters as one delimiter. For example, a source file contains the following record: abc~def|ghi~|~|jkl|~mno. If you specify the delimiter as ( ~ | ), Data Integration reads the record as three columns separated by two delimiters: abc~def|ghi, NULL, jkl|~mno. If you disable this option, Data Integration reads the record as nine columns separated by eight delimiters: abc, def, ghi, NULL, NULL, NULL, jkl, NULL, mno. |
Text Qualifier | Character to qualify text for delimited files. |
Escape Character | Escape character for delimited files. |
Field Labels | For delimited files, determines whether the task generates the field labels or imports them from the source file. If you import them from the source file, enter the row number that contains the field labels. |
Fixed Width File Format | File format to use for fixed-width files. If the list includes multiple fixed-width file formats with the same name, use the project and folder location that's appended to the name to determine the appropriate file format to use. If there are no available fixed-width file formats, select New > Components > Fixed-Width File Format to create one. |