Hello all,
I am trying to copy a database from Oracle to SQL 2000 using DTS, and in the
process encounter the following error message:
"Error converting data type DBTYPE_TIMESTAMP to datetime"

Any suggestions on what to do or what a good workaround might be?

I've alternatively tried creating a view that will replicate the database,
but encounter snags there too, as I can't seem to cleanly copy dates from
Oracle to SQL 2000. The best I can do in that situation is do a to_char() on
the Oracle date, but it is a string in SQL 2000 instead of a date, which
isn't really what I want.

I've thought of setting up an Oracle -> SQL 2000 replication, but haven't
tried it yet. If you think I should persue this option instead of chasing
after DTS or replication through a view, please let me know. I glimpsed at
Hillary Cotter's book and have considered what she describes.

Unfortunately, I don't have any write access permissions to the Oracle DB,
only SQL 2000, in case you're wondering.

Thanks so much,
Jim Bethancourt
jimbethancourt (AT) _nospam_gmail (DOT) com