Loading Data from Text Files

Advanced ETL Processor Reader Object is capable of extracting data from delimited or fixed width files. All parameters are user definable.  It can also skip a number of Header and Footer lines

 To change Reader Object properties double click on it.

  One of the benefits of using Advanced ETL Processor is ability to load several files in one go. Provided that the files are in same format all you need to do is specify mask and they will be loaded automatically.   

 Reader Properties dialog also defines format of Rejected records file.

Data Vieiw

Once all the parameters for the source file are set we can open it and see the actual data

Data View Tool bar

1. Reader Properties
2. Refresh Data
3. Edit file in external editor
4. Add new column
5. Delete last column
6. Switch to Data View
7. Switch to Data Definition View

Data Definition View

Note:

Data Definition View Tool bar

1. Reader Properties
2. Refresh Data
3. Print Data Definition
4. Print Preview Data Definition
5. Find
6. Edit file in external editor
7. Add new column
8. Delete last column
9. Switch to Data View
10. Switch to Data Definition View

About Advanced ETL Processor

Advanced ETL Processor is a Codeless ETL Tool.
It is designed to automate extracting data from ANY database, transform, validate it and load into ANY database .

Users can create Data transformations and Sql scripts add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

Watch Online Flash Demo
Download Advaced ETL Processor now