DTS Designer in SSMS 2008

[Bruce]

Has anyone been able to get the DTS designer to work in the 2008 management
studio? I had it working in 2005 SSMS, now it will not work in either SSMS.
I've tried all combinations of uninstalling the DTS components, and also
copying over the DLLs as mention in the Microsoft article. The 2008 SSMS
still says that:

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)

[h***@googlemail.com]

HasanyonebeenabletogettheDTSdesignertoworkin the2008management
studio? I had it working in 2005 SSMS, now it will notworkin either SSMS.
I've tried all combinations of uninstalling theDTScomponents, and also
copying over the DLLs as mention in the Microsoft article. The2008SSMS
SQL Server 2000DTSDesignercomponents are required to editDTSpackages.
Install the special Web download, "SQL Server 2000DTSDesignerComponents"
to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

I had the same issue until I found the following page:

http://msdn.microsoft.com/en-us/library/ms143755.aspx

Follow the instructions at the bottom regarding copying files around
and you should then be up and running. The only difference in my setup
was that the files were located in a sub-folder named ..\Resources
\1033 rather than just ..\Resources

Cheers
Chris

[Bruce]

Thanks, I had already tried this as well and couldn't get it to work even
after copying the files. Are you using Vista?

Post by h***@googlemail.com

HasanyonebeenabletogettheDTSdesignertoworkin the2008management
studio? I had it working in 2005 SSMS, now it will notworkin either SSMS.
I've tried all combinations of uninstalling theDTScomponents, and also
copying over the DLLs as mention in the Microsoft article. The2008SSMS
SQL Server 2000DTSDesignercomponents are required to editDTSpackages.
Install the special Web download, "SQL Server 2000DTSDesignerComponents"
to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

http://msdn.microsoft.com/en-us/library/ms143755.aspx
Follow the instructions at the bottom regarding copying files around
and you should then be up and running. The only difference in my setup
was that the files were located in a sub-folder named ..\Resources
\1033 rather than just ..\Resources
Cheers
Chris

[Jay]

I'm having this same issue on Vista computer, but works on XP.

Post by Bruce
Thanks, I had already tried this as well and couldn't get it to work even
after copying the files. Are you using Vista?

Post by h***@googlemail.com

HasanyonebeenabletogettheDTSdesignertoworkin the2008management
studio? I had it working in 2005 SSMS, now it will notworkin either SSMS.
I've tried all combinations of uninstalling theDTScomponents, and also
copying over the DLLs as mention in the Microsoft article. The2008SSMS
SQL Server 2000DTSDesignercomponents are required to editDTSpackages.
Install the special Web download, "SQL Server 2000DTSDesignerComponents"
to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

http://msdn.microsoft.com/en-us/library/ms143755.aspx
Follow the instructions at the bottom regarding copying files around
and you should then be up and running. The only difference in my setup
was that the files were located in a sub-folder named ..\Resources
\1033 rather than just ..\Resources
Cheers
Chris

[Davide]

Hi, I get the same problem on Vista, but it works fine on windows server
2003.
Could it be because of mmc differences on Vista?

Dave