MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

Understanding How SSIS Is Different from DTS

If you used DTS in the past, it's useful to look at how SSIS is different, because you might run into a backward compatibility question on the exam. In this section, we'll cover some of the improvements made in SSIS as well as how DTS functions in the SQL Server 2005 environment.

Here's how SSIS is different from DTS:

• SSIS now runs as a service and in fact doesn't even require SQL Server 2005 to be installed to function (but you still need the license!).
• SSIS was completely rewritten to use .NET objects and concepts. The most visible place you'll notice this is when you write scripts; you'll use the Visual Studio 2005 editor with IntelliSense instead of the old loosely typed VBScript, and you should ...