General discussion
March 12, 2004 at 08:54 PM
glennmcwilson

Using SQL with an Oracle Data Warehouse

by glennmcwilson . Updated 22 years, 6 months ago

I connect to a Oracle data warehouse across a VPN using SQL Server 2000. Apparently, Oracle was setup to accept dates, such as, 12/1/1900 or 5/31/5000. SQL Server doesn’t like such dates and every time I run a DTS to populate my local tables, it crashes and stops everything from transferring when it comes across such dates. I tried filtering, by using a SQL Statement that includes a criteria in all date fields:
Is Null or <12/31/2005 or >1/1/1940

However, I get a “fatal error” when I attempt to run the DTS. Any suggestions? Thanks for any help!

Glenn

This discussion is locked

All Comments