Posted by Dan Guzman on 02/12/07 12:35

To edit legacy DTS packages from SQL Server Management Studio, you need to
download and install the SQL Server 2000 Designer components. This is one
of the Feature Pack downloads available at
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

SSIS packages are created using the separate SQL Server Business
Intelligence Development Studio IDE rather than within SSMS. Although there
is a learning curve to get up to speed on SSIS, it is much more powerful
than DTS. Consider doing new development under SSIS rather than DTS.


--
Hope this helps.

Dan Guzman
SQL Server MVP

<othellomy@yahoo.com> wrote in message
news:1171265354.421793.133480@q2g2000cwa.googlegroups.com...
>I think SQL Server 2005 is nothing but SQL Server 2000 Query Analyzer
> *improved*. However, Server 2000 (Enterprise Manager) has lot more
> features (for example dts) and SSIS is not the answer because when I
> installed Server 2005 it don't get installed automatically.
>
> On Feb 12, 10:05 am, othell...@yahoo.com wrote:
>> 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 -- Hide quoted text -
>>
>> - Show quoted text -
>
>

[Back to original message]