Oracle 10g timestamp importing into SQL Server as clob

Question

We're importing an Oracle 10g database into SQL Server 2008.

When using the 'SQL Server Import and Export Wizard', the Oracle fields with a datatype of 'timestamp(6)' get converted into a 'CLOB' in SQL Server.

Why doesn't it get converted into a 'date' datatype?

Answer 1

I'm having this problem too! I've tried using timestamp(3)... even timestamp(0)... but it didn't work... it still maps timestamp as clob. Any clue??

Thanks!! Daniela.