Loading data from a Flat File(s)

Visual Importer ETL can load data from ASCII and Unicode files in UTf8, UTF16BE and UTF16LE formats with BOM marker and without

Unicode is a computing industry standard allowing computers to consistently represent and manipulate text expressed in most of the world's writing systems.

To perform data mapping:

  • Click Data Target Options button

  • Dialog box will appear
  • Select appropriate target type

  • Click Get tables list
  • Select Table you would like to import data into from the Drop Down List

  • Click Transformation tab
  • Select Add Records
  • Click OK
  • Click Data Source Option Button

  • Dialog box will Appear

  • Set Delimiter and Quota to appropriate values
Note: If you want to load data from several files specify a mask.

Click OK. Click and select the file you would like to import data from.

  • Select Fist field in the Data Target fields list and drag and drop it above [F1] field.

You may change field mapping by using the mapping panel at any time.

If the Data Source and Data Target have got the same fields’ names you may use the Automap feature.

Click , Fill in all necessary data and click map.

Now we are ready to import data. Let’s check the script first. Click to check script.

Here is an example of the error, the date format is missing.

Click to load data into the database

Once loading is finished you may check the Log file or the Rejected records file.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

14/06/2015 07:02 · admin
  • aetle/import/load_data_from_flat_files.txt
  • Last modified: 15/05/2018 08:02
  • by admin