I used DTS to transform data from ORACLE 8.1.7 to SQL Server 2000. an error
message appears while moving data in new table

DBTYPE_DBTIMESTAMP "Data overflow. Invalid character value for cast
specification".


field in oracle with Date type.
the retrived information through oracle ODBC test utility has formate
"DD-MM-YYYY HH:MM:SS".

How can I overcome this problem

The range for datetime in Oracle is different from SQL
Server. That's likely the issue - you are hitting a date in
the Oracle databases that has a value outside of the range
SQL Server supports. You'd need to check the Oracle values
to verify.

-Sue

On Sun, 27 Mar 2005 03:23:02 -0800, "Adel"
<Adel (AT) discussions (DOT) microsoft.com> wrote:

Thank you "Sue Hoegemeier" for your effort.

if I didn't missunderstand what you have written, the range of dates in used
in the table between 1-1-1998 to 25-3-2005 which I think it falls in range of
SQL server dates.



"Sue Hoegemeier" wrote:

Depending on what task you are using, you can put the data
in a format SQL recognizes with TO_DATE from the Oracle
side. If you are using T-SQL, you can use convert - for
example with your data:
declare @date as datetime
set @date = convert(datetime, '25-3-2005', 104)
select @date

-Sue

On Sun, 27 Mar 2005 23:21:02 -0800, "Adel"
<Adel (AT) discussions (DOT) microsoft.com> wrote: