ETL+ Troubleshooting

In this section

ETL+ Installation Troubleshooting — ETL+ not starting or crashing.

Extraction Errors

Upsert Missing or Duplicating Rows

ETL+ Error Messages — Text of error messages reported in ETL+ log files or on ETL+ screens.

T-SQL String Constants (String Literals) — ETL+ target tables (tables and columns shown in the ETL Objects panel) only support string constants with single quotation marks, (not double quotation marks).

"Driver installation failure" "Access database engine" / Excel — Error message when attempting to open an Excel, .csv or MS Access file.

Access Database Engine: Required for ETL+ Excel, .csv & MS Access — ETL+ requires that the Microsoft Access database engine 2016 is available as a driver in order to read / connect, as data sources, to MS Excel workbooks, .CSV, text, and MS Access databases.

Convert version? Message. — Message: Convert version? Please confirm you want to convert from version <prior-version> to version <current-version>.

Warning: CSV ... has duplicated column name(s) — Warning: CSV <csv-file-name> has duplicated column name(s): <column-name>. ETL+ is mapping only the first occurrence of each column.

Other Troubleshooting Pages

ETL+ Issues Importing from Excel Also .csv and Microsoft Access files

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.