dbTalk Databases Forums  

DTS Designer in SSMS 2008

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Designer in SSMS 2008 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bruce
 
Posts: n/a

Default DTS Designer in SSMS 2008 - 09-04-2008 , 04:04 PM






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)


Reply With Quote
  #2  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM






On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #3  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM



On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #4  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM



On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #5  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM



On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #6  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM



On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #7  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM



On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #8  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM



On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #9  
Old   
howarthcd@googlemail.com
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 04:00 PM



On Sep 4, 10:04*pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
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



Reply With Quote
  #10  
Old   
Bruce
 
Posts: n/a

Default Re: DTS Designer in SSMS 2008 - 09-08-2008 , 05:06 PM



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 (AT) googlemail (DOT) com" wrote:

Quote:
On Sep 4, 10:04 pm, Bruce <Br... (AT) discussions (DOT) microsoft.com> 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.