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