Importing data from JD Edwards into SQL Server

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

Many thanks,

SteveYou're probably right about the number of NGs but I need an answer in a
hurry and wasn't sure which was the most appropriate NG - apologies to
anyone who is inconvenienced!

Thanks for your response - I expected to use DTS but someone (at JDE!!)
mentioned that I may need to use XPI. Is it simply a case of using the
generic OLEDB connection object?

"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:#psjMErSDHA.1688@.TK2MSFTNGP11.phx.gbl...
> I am not sure you needed to include so many NGs on your To: line
> One World - Sat on what back end.
> We have One World sat on SQL Server. We have World sat on an AS400. We
use
> DTS.
> --
> ---------
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Steve McDonald" <ajones1@.nsw.bigpond.net.au> wrote in message
> news:7rPQa.4947$wU5.1377@.news-server.bigpond.net.au...
> > Can anyone help me??! What is the best way to import data from One World
> > into SQL Server? If it's possible to use DTS then should I use the OLEDB
> > connection object?
> > Many thanks,
> > Steve|||Many thanks for your help, Allan.

"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:uZ4DFVrSDHA.2092@.TK2MSFTNGP10.phx.gbl...
> We use the SQL Server connection object to link to the One World SQL
Server
> System and Client Access drivers for the AS400
> --
> ---------
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Steve McDonald" <ajones1@.nsw.bigpond.net.au> wrote in message
> news:cLPQa.4982$wU5.3565@.news-server.bigpond.net.au...
> > You're probably right about the number of NGs but I need an answer in a
> > hurry and wasn't sure which was the most appropriate NG - apologies to
> > anyone who is inconvenienced!
> > Thanks for your response - I expected to use DTS but someone (at JDE!!)
> > mentioned that I may need to use XPI. Is it simply a case of using the
> > generic OLEDB connection object?
> > "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> > news:#psjMErSDHA.1688@.TK2MSFTNGP11.phx.gbl...
> > > I am not sure you needed to include so many NGs on your To: line
> > > > One World - Sat on what back end.
> > > > We have One World sat on SQL Server. We have World sat on an AS400.
We
> > use
> > > DTS.
> > > > --
> > > > ---------
> > > Allan Mitchell (Microsoft SQL Server MVP)
> > > MCSE,MCDBA
> > > www.SQLDTS.com
> > > I support PASS - the definitive, global community
> > > for SQL Server professionals - http://www.sqlpass.org
> > > > > > "Steve McDonald" <ajones1@.nsw.bigpond.net.au> wrote in message
> > > news:7rPQa.4947$wU5.1377@.news-server.bigpond.net.au...
> > > > Can anyone help me??! What is the best way to import data from One
> World
> > > > into SQL Server? If it's possible to use DTS then should I use the
> OLEDB
> > > > connection object?
> > > > > > Many thanks,
> > > > > > Steve
> > > > > >