Hi, I am trying to importing data to my SQL Server DB using DTS but I am
getting errors. I don't have control over Orcale and looks like the errors
occur on DataTime fields. Here is the error message: "Error at Destination
for Row number 103299, Errors encountered so far in this task: 1. Insert
error, column 5('ROLE_END_DATE", DBTYPE_DBTIMESTAMP), status 6: Data
overflow. Invalid character value for cast secification."
Anybody have ever seen this? Thanks in advance for any help!
--
Yuhong

The range for datetime in Oracle is different from SQL
Server. That's quite possibly the issue. You'd need to check
the Oracle values to verify.

-Sue

On Tue, 15 Feb 2005 07:19:01 -0800, Yuhong
<Yuhong (AT) discussions (DOT) microsoft.com> wrote:

Thanks, Sue! I will check with our Orcale people.

"Sue Hoegemeier" wrote: