Analytics Software

Hi Guru's,

I am having a serious problem extracting data from JD Edwards into a MS SQL table via ODI.

The JDE table format (datastore) is as follows:

No. Type Log Length Scale Not Nulls
1 float 53 0 true
2 nchar 25 0 true
3 nchar 10 0 true
4 nchar 10 0 true
5 nchar 12 0 false
6 nchar 3 0 false
7 numeric 18 0 false
8 nchar 3 0 false
9 nchar 12 0 false
10 nchar 3 0 false
11 float 53 0 false
12 float 53 0 false
13 nchar 4 0 false
14 nchar 3 0 false
15 nchar 6 0 false
16 nchar 8 0 false
17 float 53 0 false
18 nchar 10 0 false
19 nchar 10 0 false
20 nchar 10 0 false
21 numeric 18 0 false
22 float 53 0 false

When I attempt to load to SQL I recieve the following error: "Error converting data type varchar to numeric"

ODI-1226: Step SPR SQL fails after 1 attempt(s).
ODI-1240: Flow SPR SQL fails while performing a Loading operation. This flow loads target table HS_ABC_In.
ODI-1227: Task SrcSet0 (Loading) fails on the source MICROSOFT_SQL_SERVER connection JDE_9.1.
Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to numeric.


I have tried the following to resolve:

1. Set my SQL table to copy the data types etc exactly as above - i get the same error
2. Used ODI interface to try and create a new target table (having deleted the old one) - same error.

Please could someone advise as I am really stuck, and running out of ideas!

Many Thanks,
Joe