471,083 Members | 1,176 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

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,

Steve
Jul 20 '05 #1
2 5570
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" <al***@no-spam.sqldts.com> wrote in message
news:#p**************@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" <aj*****@nsw.bigpond.net.au> wrote in message
news:7r*****************@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


Jul 20 '05 #2
Many thanks for your help, Allan.

"Allan Mitchell" <al***@no-spam.sqldts.com> wrote in message
news:uZ**************@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" <aj*****@nsw.bigpond.net.au> wrote in message
news:cL*****************@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" <al***@no-spam.sqldts.com> wrote in message
news:#p**************@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" <aj*****@nsw.bigpond.net.au> wrote in message
news:7r*****************@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
>
>



Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Little PussyCat | last post: by
3 posts views Thread by Elmo Watson | last post: by
4 posts views Thread by Roy | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.