Breadcrumbs

ETL+ Source Driver for Text Files (.CSV)

Creates and manages that connect to CSV files. The CSV files can be on a local folder or on a web page.

v2026.01

Text File Page

image-20250129-005737.png
Source Objects panel toolbar

Add Source: New Text File (.csv) connection.

Properties: Maintain Text File connection.

Refresh: Update source Text File database metadata.

Where to Find in ETL+
image-20260218-055227.png

  • Alias. The name for the source object shown on the Source Objects panel. Unless customized the name will be automatically generated based on the last folder (directory) in File Path.

  • Schema: Check this box if you want all target tables from this source to be assigned into a SQL schema named <Schema Name>.

  • File Path. Enter a local file path containing the .csv or .txt files, a internet URL, or IP address.

  • Browse. Browser function to local the File Path.

  • Delimiter. Always dimmed.

  • First Row has Column names. Checkbox is always dimmed but always selected.

  • Device: Be sure to set the Device to a computer with direct access to the text folder/files.

  • Back. Leave the page without saving or attempting to connect.

  • Connect. Connect to the Text File source. Same function as Refresh.

image-20230813-001241.png

Help
image-20230813-001426.png

Change DataSource. Only shown when opened by Properties.
:notes5:

File Path can have a Windows path, URL to a web page or IP address.

  • .txt files are treated as .csv files.

Examples

The .csv files recognized by the driver are based on the File Path. In this example the File Path C:\Users\Public\ETL+ Beta\CWTests contains the files csv1.csv and csv2.csv.

image-20230825-053825.png

Connecting to the csv1.csv file

csv1.csv file

image-20230825-054515.png


Preview page

image-20230825-054716.png


csv1 target table

image-20230825-055228.png



How to Add Connections to .CSV Files

  1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

  2. Select Add Source > Text File

For more see the Text File Page section above.

How to Maintain Text File Connections

  1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

  2. Select a Text File based Source Object on the Source Objects panel.

  3. Select Properties

For more see the Text File Page section above.

CSV Data Format

A CSV (Comma-Separated Values) file is a simple and widely used file format for storing tabular data, such as spreadsheets and databases, in a plain text format. CSV files are commonly used to exchange data between different software applications, databases, and platforms due to their simplicity and ease of use.

Position in the ETL+ Interface