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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy