Posted by Dan Guzman on 02/09/07 12:40

DTS is replaced with SSIS (SQL Server Integration Services) in SQL 2005. If
you upgrade from SQL 2000, you'll find your old DTS packages in SQL Server
Management Studio Object Explorer under Management-->Legacy-->Data
Transformation Services. However, note that SQL Server 2005 includes DTS
only for backwards compatibility; it's recommended that you use SSIS for new
development.

See the SQL Server 2005 Books Online for more information
(http://msdn2.microsoft.com/en-us/library/ms143706.aspx).

--
Hope this helps.

Dan Guzman
SQL Server MVP

<othellomy@yahoo.com> wrote in message
news:1171023589.200822.236990@k78g2000cwa.googlegroups.com...
> Why is dts packages out of server 2005? In server 2k they were there
> but in 2005 it's gone? I tried to connect to 2k using 2005 client
> interface and can't seem to locate the dts packages I seem to notice.
>

• Next in forum: Re: Optimizing a big query
• Prev in forum: Where is my dts?
• Thread view: Re: Where is my dts?

[Reply to this message]