If the source database is a SQL Server database and the destination
database is a SQL Server database, do you need to use DTS? Is it
possible to use a stored procedure instead? Are there advantages to
the stored procedure solution?

The answer is as always "It depends"

DTS allows you to do some funky stuff which is very difficult in a
stored proc.
It also allows you to traverse a lot of datasources effortlessly.
It will provide you with a GUI which is pleasing at which to look.
Great logging ability

That said.

If all you want to do is move data from a SQL Server DB to a SQL Server
DB with no particular fancy stuff in the middle then why invoke DTS if
an SP will do it?

Allan


"imani_technology_spam (AT) yahoo (DOT) com" <imani_technology_spam (AT) yahoo (DOT) com>
wrote in message news:imani_technology_spam (AT) yahoo (DOT) com:

Which would have faster peformance, a DTS script or a stored procedure
with linked (SQL) servers?

Again

That depends.

Linked server using 4 part naming performance generally sucks but you
can get some good perf on OPENROWSET etc.

Have a go and notice the trade offs.

It also comes down to maintainability.


"imani_technology_spam (AT) yahoo (DOT) com" <imani_technology_spam (AT) yahoo (DOT) com>
wrote in message news:imani_technology_spam (AT) yahoo (DOT) com: