...
Changes to Microsoft Windows security can impact ETL+'s ability to read the Excel file.
In some cases rebooting the computer fixes the problem.
Software Requirements
See /wiki/spaces/DS/pages/1920270337
Microsoft Excel Files
Causes of failure include
...
The driver determines the length (size) of the string extracted from the Excel column by reading the first few rows in Excel. The driver alone determines the maximum length of the character string it will extract. The driver does not look at the size of the destination string in the ETL SQL Statement panel or ETL Objects panel.
If, for instance, the driver determines the maximum length of a string in a Excel column is 30 it will only extract the first 30 characters from that column even if the ETL SQL Statement panel and ETL Objects panel show a destination field that is
varchar(255).Another example is if the driver determines the data type of the column is float because the first few rows are integers, when, in fact, the column’s data type should be varchar(255), any row that has a value that cannot be interpreted as a float will be replaced with a NULL value.
Changing the string size in the ETL SQL Statement panel or in the destination table in the ETL Objects panel will not prevent truncation.
The workaround for these issues is to add a dummy first row with a value(s) in the column(s) you want to force the driver to interpret correctly. For example, if the requirement is for a column to have a data type of varchar(max), then add a value greater than 255 characters in the dummy row column.
...