Error converting data type DBTYPE_DBTIMESTAMP to datetime

  • 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

  • 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