General discussion


Using SQL with an Oracle Data Warehouse

By glennmcwilson ·
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!


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums