Problem with double SQL Server (ODBC)
Posted: Thu Apr 19, 2018 2:58 am
Hi.
I'm a problem inserting floatig values, in a SQL Server db, in the field "MVPREZZO" defined as below:
The job is very simple:
I can't find a metadata combination that works fine. I tried both decimal format separator in the input CSV file.
With "." decimal separator in the input file I get the error:
Thanks,
Andrea
I'm a problem inserting floatig values, in a SQL Server db, in the field "MVPREZZO" defined as below:
[MVPREZZO] decimal(18, 5) NULL
The job is very simple:
The only data type I can use on the target ODBC stage to avoid the warnig "SQLColAttributes(MVPREZZO) gave MetaData mismatch" is "Decimal".CSV -> transformer -> ODBC Stage
I can't find a metadata combination that works fine. I tried both decimal format separator in the input CSV file.
With "." decimal separator in the input file I get the error:
With "," decimal separator in the input file I get the error:SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client]Non-numeric data was found where numeric required
XORDERDETAILID = "SGR000000001"
XORDERID = "SGR000000001"
MVCODICE = "CALD_MANUTENZIONE"
MVDESART = "Manutenzione Caldaia"
MVPREZZO = 62.95081967
MVCODIVA = "22"
CPCCCHK = "XXX"
Can someone help me ?SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
XORDERDETAILID = "SGR000000001"
XORDERID = "SGR000000001"
MVCODICE = "CALD_MANUTENZIONE"
MVDESART = "Manutenzione Caldaia"
MVPREZZO = 62,95082
MVCODIVA = "22"
CPCCCHK = "XXX"
Thanks,
Andrea