SQL Server Performance Forum – Threads Archive
MSSQL 2000 Linked to Oracle 8I 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
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.
Have you tried Data Transformation Services (DTS)? Nathan H.O.