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)
On Sep 4, 10:04 pm, Bruce wrote: > 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 > still says that: > > 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
Thanks, I had already tried this as well and couldn't get it to work even after copying the files. Are you using Vista? "howarthcd@googlemail.com" wrote: > On Sep 4, 10:04 pm, Bruce wrote: > > 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 > > still says that: > > > > 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 > >
I'm having this same issue on Vista computer, but works on XP. "Bruce" wrote: > Thanks, I had already tried this as well and couldn't get it to work even > after copying the files. Are you using Vista? > > "howarthcd@googlemail.com" wrote: > > > On Sep 4, 10:04 pm, Bruce wrote: > > > 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 > > > still says that: > > > > > > 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 > > > >
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
