English

Error: Microsoft OLE DB Provider for SQL Server: Invalid character value for cast specification.

Error Message

The following errors may occur, together, in data loading utilities such as cov2sde and shp2sde.

102999 Underlying DBMS error(Microsoft OLE DB Provider for SQL Server:
Invalid character value for cast specification.)

103000 Underlying DBMS error(Microsoft OLE DB Provider for SQL Server:
Invalid character value for cast specification.)

Cause

Trying to load values from the data source into RDBMS columns that are too small (numerically speaking) for particular values.

Solution or Workaround

Try one of these solutions:

  • Remove the values suspected to be too large.
  • Increase the size of the column containing the suspected values.