Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Open DTS package with SQL 2008 management studio

Author  Topic 

BurningBrain
Starting Member

1 Post

Posted - 2010-05-24 : 03:32:24
When I try to open DTS package, I get the message

"Managing DTS packages in SQL Server Management Studio requires the SQL Server 2000 Data Transformation Services (DTS) runtime. To install the DTS runtime, on your SQL Server 2008 installation media, locate and run the Windows Installer package for SQL Server 2005 Backward Compatibility (SQLServer2005_BC*.msi). You can also download the DTS runtime from the SQL Server Feature Pack page on the Microsoft Download Center. (Microsoft.SqlServer.DtsObjectExplorerUI)"

When I install SQL Server 2005 Backward Compatibility (SQLServer2005_BC.msi), the new message is

"SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)"

When I install this (SQLServer2005_DTS.msi), I still get the same message.

Please tell me what am I doing wrong. Can I help myself with Visual Studio 2010 Premium ?

Thanks in advance
   

- Advertisement -