I'm trying to export some data from a txt file (quite large: more then 1300 columns, pipe delimited, from 5 to 100 rows) into a postgresql db table.
Here my problems:
Reader module
- setting field's name to 0 returns an error: "Access violation at address ...... in module 'AdvancedETL.exe'. Read of address ......" After that, any operation on reader module returns a similar error (.... Write of address....)
- no way to manual set field's names ? (seems fine only when the input file has at least an header row)
- using Auto format grid in reader module lead to a cpu load next to 100% (a manual width set to the exact number of columns seems fine but sometimes the program become unresponsive)
Validator & Transformer
- any attempt to open the editor locks the program for minutes (more than 15 minutes to open!!!)
Notice that the same operation with Visual Importer proceeded without problems.
I can PM the text file if needed
Regards
C