Very Computer

I am attempting to move an Oracle 8i database to SQL
Server 7.0. All numeric values are transfered with a 0
value. Any ideas?

Hello,

Does the column with the numeric data type has no length specified? (no
precision, no default, allows NULL). The numeric data type without a
precision and scale is represented in Oracle by a variable-length numeric
with precision of up to 255. There is no SQL Server type that htis can be
mapped to without loss of precision.

Please make sure you have at least SP2 applied on the target machine. and
you may try the following work around:

1. Set the leng property for Numeric column in Oracle table.
2. Use transform to convert the data in the numeric field to a character
value (you may convert it back later).
3. The best work around is to change the field type in the table to a
defined value, such as Numeric (15), if possible.

I hope this helps.

Regards,
Jun Chen

This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks for your reply.

The field does have a length (18). I am going to install
the service pack 3, however I did not see anything in it
that related to our problem.

The problem seems to arise before the transfer begins.
When I view the data via the preview it shows 0's. I have
also tried creating the tables to import into prior to the
transfer and it doesn't make a difference.

Quote:>-----Original Message-----
>Hello,

>Does the column with the numeric data type has no length
specified? (no
>precision, no default, allows NULL). The numeric data
type without a
>precision and scale is represented in Oracle by a

variable-length numeric

Quote:>with precision of up to 255. There is no SQL Server type
that htis can be
>mapped to without loss of precision.

>Please make sure you have at least SP2 applied on the

target machine. and

Quote:>you may try the following work around:

>1. Set the leng property for Numeric column in Oracle
table.
>2. Use transform to convert the data in the numeric field
to a character
>value (you may convert it back later).
>3. The best work around is to change the field type in
the table to a
>defined value, such as Numeric (15), if possible.

>I hope this helps.

>Regards,
>Jun Chen

>This posting is provided "AS IS" with no warranties, and
confers no rights.

>.

Afetr installing SP3. , when we go to preview we get
a "field type out of range" message.
I came across another post here that says DTS only works
with Oracle 7. Do you know if this is the case?

Quote:>-----Original Message-----
>Thanks for your reply.

>The field does have a length (18). I am going to install
>the service pack 3, however I did not see anything in it
>that related to our problem.

>The problem seems to arise before the transfer begins.
>When I view the data via the preview it shows 0's. I have
>also tried creating the tables to import into prior to
the
>transfer and it doesn't make a difference.

>>-----Original Message-----
>>Hello,

>>Does the column with the numeric data type has no length
>specified? (no
>>precision, no default, allows NULL). The numeric data
>type without a
>>precision and scale is represented in Oracle by a
>variable-length numeric
>>with precision of up to 255. There is no SQL Server type
>that htis can be
>>mapped to without loss of precision.

>>Please make sure you have at least SP2 applied on the
>target machine. and
>>you may try the following work around:

>>1. Set the leng property for Numeric column in Oracle
>table.
>>2. Use transform to convert the data in the numeric
field
>to a character
>>value (you may convert it back later).
>>3. The best work around is to change the field type in
>the table to a
>>defined value, such as Numeric (15), if possible.

>>I hope this helps.

>>Regards,
>>Jun Chen

>>This posting is provided "AS IS" with no warranties, and
>confers no rights.

>>.

>.

Hello,

The following article may be helpful:

http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q199293

You may also use Oracle ODBC driver if you are using ODBC connectivity. You
may also consider converting the data in the numeric field to a character
value (then convert it back).

Jun

This posting is provided "AS IS" with no warranties, and confers no rights.