Auto Casting Oracle column to Sql Server 2005 native type

Question

Hi all

I have a Oracle linked server (10.g) on a Sql server 2005. Trying to import oracle table schema(s) into SQL using

Select * into ttdsls030010 
from openQuery(hades,'select * from baan.ttdsls030010 where rownum =1');

This throws an Error converting data type DBTYPE_DBTIMESTAMP to datetime

Is there a way to autocast Oracle type to Sql type ?

p.s: Essentially, although it is possible to cast type in Oracle using to_char() etc. The notion here is that Oracle table schema could change any time i.e adding or deleting columns. If such has happened, I need to refresh local (sql) schemas to correspond to that of Oracle.