DTS (Oracle to SQL Server 2000)

I am trying to convert an application database from Oracle to SQL Server 2000. I am using Data Transformation Services utility provided by SQL Server. I am converting data on table-by-table basis. However, whenever I convert DATE fields (form Oracle) into DATETIME fields (to SQL Server 2000), my tasks fails. Does anyone knows the reason and, more important, a solution to this problem ?Hi

I'm also working with an Oracle Database.

In my configuration it works.
I used a Transform data task and the transformation I used is a copy column.

So

Oracle:
numeric/field1, datetime/field2 >> source in Transform data task

SQL Server 2000:
numeric/field1, datetime/field2 >> destination in Transform data task

Transformations: let SQL Server do automapping, copy column.

Greetings
Jon@.s