We're having trouble using a DTS Data Transform Task to move data from
SQLServer to Oracle and more specifically from SQLServer DateTime to Oracle
Timestamp.

We set up the source table (SQLServer) just fine but when we click on the
destination tab it gives us an "Unspecified Error" when trying to read the
ORACLE schema for the table that contains the timestamp. If we change the
column type in ORACLE to "Date" it works fine however we need the time
element in the column.

Any Suggestions?

Thanks