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