Text (txt, csv)
The Text (txt, csv) connector is an object that is used to get data from text files (*.txt, *.csv).
After adding the connector to the ETL task working area, set import options, edit connector output.
Import Options
The properties panel is used to specify a file with imported data and parameters that are used to determine a data range.
To display the properties panel
The following settings are available on the properties panel:
File Import Method. Select method for getting file:
Specified Path. The radio button is selected by default, and the file path box is active. After the path is entered, the file is imported, and one can continue set up using file structure. When executing ETL task, the file is also searched at the specified path.
Request File on Task Execution. Select this checkbox if it is required to select file on each ETL task execution. To execute primary setup of the data provider, click the
Add button in the Setup File box:
The local file selection dialog box opens. Working with the dialog box order depends on the browser in use. After the file is selected, it is saved to the folder with user operating system. The file will be used only during the current wok with the ETL task instance. After the task is closed, the file is deleted from the temporary folder.
When executing ETL task, the file selection dialog box opens. If structure of the selected file does not correspond to the file used during the setup, an exception is thrown.
Object Name. If required, change connector name.
Identifier. If required, change object identifier. Identifier should be unique with the ETL task. Usage of Latin letters, numbers and the "_" character is allowed. The identifier should start with a letter.
NOTE. If required, add a note to an object. The note can contain any information.
Data Import Options from Text File. Specify the header row number and row delimiter:
Skip First N Rows. Specify the number of rows to be skipped.
Header Row. The 1 value is set by default, header names are created based on the data from the document's first row. To use the other row, enter the number of the corresponding row, from which header names will be obtained.
NOTE. If a zero row is specified in the box, it is assumed that there are no headers.
Encoding. Specify encoding to be used on file parsing. The list contains system code pages, the following encodings are used on their selection:
System Code Page (Windows). ASCII encoding is used.
System Code Page (UNICODE). UTF-16 (LE) encoding is used.
System Code Page (DOS). OEM encoding is used.
Row Delimiter. Select a row delimiter in the list or specify a custom one in the source file.
Column Delimiter. Text Qualifier. Each file line is regarded as a set of fields divided by a delimiter. Field text beginning and end are marked with a qualifier. Using appropriate fields, select or enter column delimiter and text qualifier.
Settings. The button is used to edit connector output.
To save the changes, click the Apply button.
To close the connector properties panel without saving, click the 
Close button.
Settings button.
Create button and select an object input. If the list of provider and consumer fields fully matches, all fields will be linked automatically. A link between fields can also be set up in the 
Actions button and select the Fill from Provider item.