I'm running a stream which uses a SQL Source node. The datasource uses the SQL Server Native Client 10.0 ODBC driver. The table in the SQL Server 2008 database has a decimal 15,5 field. Running the stream gives below error. Error Message: 22003 [Microsoft][SQL Server Native Client 10.0]Numeric value out of range
Resolving The Problem
This problem has been reported to SPSS Development - Workaround Available
This is working as designed.
As a workaround, use float instead of decimal.
More information about he use of float and decimal can be found in the Help of SQL Server 2008
16 June 2018