ERROR

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

Last Published: April 25, 2020

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.

Article ID:000002336

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic