Where Is DTS in SQL Server 2005?

You might have worked with DTS, provided with SQL Server 2000. DTS is not an independent application in itself; rather, it is an integral component of SQL Server 2000. DTS is a nice little tool that has provided all of us with great functionality and components. Some developers have even extended DTS packages by writing custom scripts to the enterprise level. Yet DTS has some inherent shortcomings: for example, it is bound to SQL Server, is not a true ETL tool, has a limited number of preconfigured tasks and components, offers a single design interface for both workflow and data flow that is limited in extensibility, and has no built-in repeating logic. Although you could fix all these shortcomings by writing ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.