DTS - Trouble converting Oracle Date columns to SQL Server DateTIme
I'm trying to copy data from an Oracle source table (using the MS OLE DB for Oracle option) to a MS SQL Server 7 table. It works fine except for the two Date columns (by default
converted to DateTIme in SQL Server).
The only odd thing I notice, is that when I preview the Oracle source, some of the years look too old (1844 for example),but even those should convert to DateTime....
How do I approach this?