Thanks for your reply, Geoff. But I've tried to transfer 1 record only with
no null value at all. Then, I've tried to convert the field to type DECIMAL
in SQL Server before transfer. The task succeeded but decimal places were
lost. I've also tried to convert to type DECIMAL(18,2), i.e. with precision
& scale specified. This time, the task failed with the same error message
"Invalid number". Please help!
Sally
> It may be that you have a NULL value from SQLServer that you are trying
> to Insert into the column on Oracle which would like a number, if you
> can change NULLs to zero's that would probably help.
> Don't know how you'd do it in SQLServer, but in SQLPlus it would be
> NVL(column_name,0)
> HTH
> Geoff
> Geoff Reader
> University of Brighton
> > Dear all,
> > What I need is to transfer data from a SQL Server table to an Oracle
table.
> > I use DTS in SQL Server to simplify the process. However, the task
failed.
> > An error 'Invalid Number' is prompted indicates an error occurs to one
> > field. The field types of the source and the destination tables are as
> > follow.
> > (SQL) numeric(18,2) --> (Oracle) number(18,2)
> > The field types look the same but the process failed. Could any body
tell
> > me why and how to solve it ?
> > Thanks for any help !
> > Sally
by