Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error converting data type DBTYPE_DBTIMESTAMP to datetime Expand / Collapse
Author
Message
Posted Friday, November 26, 2010 12:28 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, December 8, 2012 8:24 PM
Points: 40, Visits: 135
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

Post #1026850
Posted Wednesday, September 5, 2012 4:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 10, 2014 11:03 AM
Points: 24, Visits: 97
Did you receive any ideas on this issue?

Mark Johnson
MCP, MCTS Sql Server 2005,MCTS Sql Server 2008, OCP
Post #1354956
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse