Can anyone help me??! What is the best way to import data from JDE (One
World) into SQL Server? If it's possible to use DTS then should I use the
OLEDB connection object?

Many thanks,

Steve

Hi Steve.

For what it's worth, I've just completed a project where DTS was used
heavily for integration between SQL Server & JDE (AS400) over IBM's Client
Access ODBC drivers and this has worked very well.

Regards,
Greg Linwood
SQL Server MVP

"Steve McDonald" <ajones1 (AT) nsw (DOT) bigpond.net.au> wrote

I am in the planning stages for a JDE/OLAP project.
I've heard that there might be an issue concerning the
scaling of numbers -- that the JDE scaling information is
stored in a separate data dictionary table.

Did you encounter this issue? If so, how did you handle it?
I've read that some odbc drivers handle this
transparently -- with the unstated implication that some
do not? Is this relevant or just marketing chaff?
Jim Callahan