Posted by Erland Sommarskog on 10/01/39 11:43

Peter Nurse (PtrNrs@yahoo.com.au) writes:
> Now why would I want to use SSIS rather than DTS?

Because SQL 2005 is new, better, faster more beautiful and all that?

To wit, the component that in SQL 2000 was known as DTS, has change
names in SQL 2005, and is now known as SQL Server Integration Services.
As I understand, it there are huge differences, as it it is a redesign
from bottom up. I would not be able to tell the difference myself,
because I've worked with neither.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Cursor looping versus set-based queries
• Prev in forum: Re: Row Numbers for a View
• Thread view: Re: SQL Server 2005: Migrate DTS to Where?

[Reply to this message]