November 26, 2010 at 12:28 pm
Good afternoon:
There is a process that somestimes fails with the error:
Error converting data type DBTYPE_DBTIMESTAMP to datetime
This error usually happnes when you import data from another sources of data like oracle.
The weird thing is that i restart the instance in sqlserver 2000 and execute once again the procedure and it works OK.
Thr problem is i cannot restart the instance everyday because there are other procedures running, and i think this is a temporary solution. but i cannot find out the "root of the problem.". dont know if it is a sqlserver problem.
is there any better solution to tackle the problem from the root?
This a part of the code
PRO_ETL_CARGUE_PS_CATEGORIAS_CARGO_TD 2900, 511188, ''
INSERT INTO DETALLE_PS_CATEGORIAS_CARGO_TD (
COD_CATEGORIA
,MIN_CARGO_REQUERIDO
,ID_CATEGORIA
,DES_CATEGORIA
,FEC_CREACION
,USU_CREACION
,MIN_CARGO_REQUERIDO
,ID_CATEGORIA
,FEC_MODIFICACION
,USU_MODIFICACION
FROM OPENQUERY (SCL,'SELECT
TD.COD_CATEGORIA
,TD.ID_CATEGORIA
,TD.DES_CATEGORIA
from PS_CATEGORIAS_CARGO_TD TD')
(1 row(s) affected)
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Id appreciate your help
September 5, 2012 at 4:58 pm
Did you receive any ideas on this issue?
Mark Johnson
MCP, MCTS Sql Server 2005,MCTS Sql Server 2008, OCP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply