Link to home
Start Free TrialLog in
Avatar of VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY

asked on

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.DtsObje

I can run the dts package from SQL2008R2 RTM version.But i couldn't get view the  dts package.
I'm getting below error:
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)SSMS


I have followed the steps from the below link

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/07/09/error-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-ssms.aspx

But still it's failing with the same error?

Is sqlserver2005_bc(x64).msi will work for SQL 2008R2?
I'm working for 3 days but no luck.
Avatar of TempDBA
TempDBA
Flag of India image

Have you modified the path and did repairing like it is said in point 4 and 5?
ASKER CERTIFIED SOLUTION
Avatar of VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY

ASKER

The msi package which was downloaded was corrupted one.
May i get the packages of sqlserver2005_BC.msi  and SQLServer2005_DTS.msi . i tried to download from internet, but all links are not working