Alex (firstname.lastname@example.org) writes:
> We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM
> work with these okay? Also I want to make sure SQL 2005 Enterprise
> Manager won't be adding to, changing, or 'upgrading' the DTS scripts or
> anything on the SQL 2000 servers as we still have folks using SQL 2000
> Enterprise Manager.
> Thanks for any suggestions. I'm always leery when using cross-versions
> of Microsoft applications because they are often incompatible or they
> do squirly things that often break stuff.
There isn't any Enterprise Manager in SQL 2005. Instead there is
SQL Server Management Studio which gathers most of the functionality in
Enterprise Manager and Query Analyzer.
To edit DTS packages on SQL 2000 with Mgmt Studio, you will need a web
download. (You will get an error message telling you this.) I would not
expect Mgmt Studio to make incompatible changes to DTS packages on SQL 2000,
but I'm not into DTS myself, so I don't know. (I don't even have that
web download installed.)
In SQL 2005 DTS has been replaced by SQL Server Integration Services. To
work with SSIS packages you use Business Intelligence Development Studio,
which really is Visual Studio under a different name.
Erland Sommarskog, SQL Server MVP, email@example.com
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at