SQL Server Performance

MSSQL 2000 Linked to Oracle 8

Discussion in 'Analysis Services/Data Warehousing' started by QFloray, Feb 7, 2004.

  1. QFloray New Member

    I have linked my sql windows 2000 sp3 server to a vendors read-only
    Oracle 8 server (soon to be 9), using OLEDB and MDAC downloaded and installed in dec 2003.

    The problem I am having is with the Oracle DateTime fields, as some
    dates are out of MS Datetime Range. I using openQuery as
    a work around with the following code for all date fields

    GREATEST(anyDateField, TO_DATE(''''1753-01-01'''',''''yyyy-MM-DD'''')) "anyDateField".

    Is there any better solution?

    Thanks



    Quentin
    QFloray, Feb 7, 2004
    #2

  2. satya Moderator

    What is the level of service pack on SQL and how about the error indication during this process?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Feb 17, 2004
    #2

  3. vbkenya New Member

    Have you tried Data Transformation Services (DTS)?

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
    vbkenya, Feb 17, 2004
    #2

Share This Page