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
> > > > > >
