The Text connector is an object that is used to export data to text files (*.txt, *.csv).
After adding the connector to the ETL task workspace, set basic properties and export options. The connector input and output can also be edited.
The Export Options page is used to specify a file for data export.
Set parameters of data export to the text file:
Text File. Specify path to data consumer file.
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 (DOS). OEM encoding is used
System Code Page (UNICODE). UTF-16 (LE) encoding is used.
System Code Page (Windows). ASCII 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 line of the consumer file shows a collection of fields separated with a special character. Field text beginning and end are marked with a qualifier. Using appropriate fields, select or enter field separator and text qualifier. These lists are available if the Separators radio button is selected.
Export Fields Headers. If the checkbox is selected, column headers are output to the first line of the text file. If the checkbox is deselected, the first line contains exported data.
Clear Consumer Before Loading Data. If the checkbox is selected, all information is deleted from the consumer before data loading.
See also: