 | |
DTS (DBTYPE_NUMERIC) error
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS (DBTYPE_NUMERIC) error -
02-06-2004
, 04:46 AM
#2
| |||
| |||
|
|
I am using DTS for import data from Navision to MS SQL DB, but i am getting this error when trying to import a BCD (15,5) into the MS SQL. Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), status 12: Invalid status for bound data. If i change the decimal(15,5) to varchar(30), i only get "- " imported into 'Pr' column. |
#3
| |||
| |||
|
|
I am using DTS for import data from Navision to MS SQL DB, but i am getting this error when trying to import a BCD (15,5) into the MS SQL. Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), status 12: Invalid status for bound data. If i change the decimal(15,5) to varchar(30), i only get "- " imported into 'Pr' column. |
#4
| |||
| |||
|
|
The source value is Pr BCD(15,5) NOT NULL, viewing the value inside Navision it looks like: 1.900,00 The driver i am using is: C/ODBC 32 bit, 2.10.00.11 I have downloaded version C/ODBC, 2.50 driver, but this was in conflict with company server driver, so i am still using version 2.10.00.11 Magni Hansen ----- Allan Mitchell wrote: ----- what do the source values look like. This sounds like a driver issue but I am interested to see the values -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Magni hansen" <mjh (AT) farodane (DOT) fo> wrote in message news:bbf801c3ec9e$7fb8a0e0$a501280a (AT) phx (DOT) gbl... I am using DTS for import data from Navision to MS SQL DB, but i am getting this error when trying to import a BCD (15,5) into the MS SQL. Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), status 12: Invalid status for bound data. If i change the decimal(15,5) to varchar(30), i only get "- " imported into 'Pr' column. |
#5
| |||
| |||
|
|
The source value is Pr BCD(15,5) NOT NULL, viewing the value insid Navision it looks like: 1.900,0 The driver i am using is: C/ODBC 32 bit, 2.10.00.1 I have downloaded version C/ODBC, 2.50 driver, but this was in conflic with company server driver, so i am still using version 2.10.00.1 Magni Hanse ----- Allan Mitchell wrote: ---- what do the source values look like. This sounds like a driver issu but am interested to see the value -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP www.allisonmitchell.com - Expert SQL Server Consultancy www.SQLDTS.com - The site for all your DTS needs I support PASS - the definitive, global communit for SQL Server professionals - http://www.sqlpass.or "Magni hansen" <mjh (AT) farodane (DOT) fo> wrote in messag news:bbf801c3ec9e$7fb8a0e0$a501280a (AT) phx (DOT) gbl.. I am using DTS for import data from Navision to MS SQL DB but i am getting this error when trying to import a BC (15,5) into the MS SQL Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), statu 12: Invalid status for bound data If i change the decimal(15,5) to varchar(30), i only get " " imported into 'Pr' column |
#6
| |||
| |||
|
|
If i change the destination column to varchar, then it only imports a "-" why is that so ?.. I have hardcoded a ASP script, which takes out the 'Pr' column value from Navision and inserts it to MS SQL in a while statement, then it's imported |
is by making a schedule for the DTS..
Quote:
|
Have you any idea what is the best solution ? Magni Hansen ----- Allan Mitchell wrote: ----- this value 1.900,00 will not go into a decimal in SQL Server. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Magni Hansen" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:C9BA82FA-A628-4F2D-B5C8-176F0597107D (AT) microsoft (DOT) com... The source value is Pr BCD(15,5) NOT NULL, viewing the value inside Navision it looks like: 1.900,00 The driver i am using is: C/ODBC 32 bit, 2.10.00.11 I have downloaded version C/ODBC, 2.50 driver, but this was in conflict with company server driver, so i am still using version 2.10.00.11 Magni Hansen ----- Allan Mitchell wrote: ----- what do the source values look like. This sounds like a driver issue but I am interested to see the values -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Magni hansen" <mjh (AT) farodane (DOT) fo> wrote in message news:bbf801c3ec9e$7fb8a0e0$a501280a (AT) phx (DOT) gbl... I am using DTS for import data from Navision to MS SQL DB, but i am getting this error when trying to import a BCD (15,5) into the MS SQL. Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), status 12: Invalid status for bound data. If i change the decimal(15,5) to varchar(30), i only get "- " imported into 'Pr' column. |
#7
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.