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?


  2. satya Moderator

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

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. vbkenya New Member

    Have you tried Data Transformation Services (DTS)?

    Nathan H.O.

Share This Page