Posted by othellomy on 02/12/07 04:05

Ok thanks. I am not very expert on dts but I followed your advice. I
could not open the packages that were already developed in 2000. After
I did a migration still no dts. When I try to open a package I get the
message that "SQL Server 2000 Designer components are required.." etc.
I did not upgrade from 2000 instead installed a new instance of Server
2005 so ended up running two different instances (one for 2000 and one
for 2005). I am not sure if SSIS will give me the flexibility of
developing simple dts using toolbox etc. Besides, installing SSIS is
not easy either.

On Feb 9, 6:40 pm, "Dan Guzman" <guzma...@nospam-online.sbcglobal.net>
wrote:
> 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
>
> <othell...@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.- Hide quoted text -
>
> - Show quoted text -

[Back to original message]