User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Example 1: Read Flat File

Follow the steps below to read the flat file data and load the data into a RowSet.

From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Read Flat File task to the Project Outline.

On the Basic tab of the Read Flat File task, specify values for the following attributes:

Input File: The file path and file name of a single file from which to read the data.
Output RowSet Variable: The name of a variable which will contain the data read from the specified input file(s).

On the Advanced tab of the Read Flat File task, specify the Record Delimiter type:

Start Row: Specify the row to start reading data from the file(s).
Skip Empty Rows: Specify whether or not to skip empty rows.
Record Delimiter: The character or sequence of characters that separate each record.