Skip to content
Ask the community about this page

Errors 'Input string was not in a correct format' and 'The given value of type... cannot be converted' in Timextender Excel Connector

Symptoms

Error while executing TDI transfer task for Timextender Excel data source. Error messages received:

Failure

Errors:

Input string was not in a correct format.

The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.

Cause

These errors occur due to the incorrect format of the input string when the data types are inferred from the Excel file. This issue can arise if the "number of rows to infer data types" setting is not configured correctly.

Resolution

  1. Change the "number of rows to infer data types" setting to 0 (i.e., scan all rows to determine data types).

    Errors 'Input string was not in a correct format' and 'The given value of type... cannot be converted' in Timextender Excel Connector — screenshot 1

  2. Execute the import metadata task for the data source in TDI desktop.

  3. Execute the transfer task for the data source in TDI desktop.

If the issue persists:

  1. Ensure that no data type overrides or changes are applied to the data source in Timextender Data Integration.
  2. Confirm that the data source is pointing to the correct file.
  3. Verify the data types in the data source explorer for the data source.

Reference Ticket

31916

Discussed in the community

Looking for related questions…

Didn't find your answer? Ask the community about this page — questions are answered by Timextender experts, partners and other users.