Hi,
I have a question? Linked Server or DTS Package? Which is
more advantageous while importing data from one SQL Srver
to another SQL Server?. If available please direct me to
any article available on the internet.

Linked Servers can in my experience be slow especially when using the 4 part
naming (use Profiler to view the data). If I use them I use OPENQUERY().
DTS has it over TSQL in it's ability to handle error flows and also the
tasks within DTS. TSQL is not too good at string parsing but in a DTS
package you can use VBScript to do it for you.

Personally I look to DTS first but that's just me <grin>

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Admin" <admin (AT) emoneylinks (DOT) com> wrote

Thanks Allen,

But this is SQL to SQL data there is no string parcing
involved. My experience is the otherway. I noticed few
times the DTS was little bit slow.

Then you go with what you are most happy. If there is nothing involved that
cannot be done in pure TSQL then go with that as you will not incur any
overhead instantiating DTS.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"admin" <anonymous (AT) discussions (DOT) microsoft.com> wrote