dbTalk Databases Forums  

Unable to load DTS within SQL 2005

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


Discuss Unable to load DTS within SQL 2005 in the microsoft.public.sqlserver.dts forum.



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

Default Unable to load DTS within SQL 2005 - 01-26-2006 , 10:26 AM






I installed the legacy component so that i can access SQL 2000 DTS packages
from within SQL 2005. It was working fine for several weeks but now I get
the following error:

"Unable to load SQL Server 2000 Data Transformation Services (DTS) runtime.
To install the DTS runtime, run the SQL Server Installation Wizard. On the
Components to Install page, click Advanced, then select Legacy Components for
installation. (Microsoft.SqlServer.DtsObjectExplorerUI)
at
Microsoft.SqlServer.Dts.ObjectExplorerUI.LegacyAct ionBase.CreateLegacyDesigner()
at
Microsoft.SqlServer.Dts.ObjectExplorerUI.OpenLegac yPackageAction.Act(INodeInformation nodeInfo)
at
Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServer MenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type)"

So I tried a repair, no luck. I then removed the dts comonent, rebooted,
and reinstalled, still getting the same message. Anyone have any idea what
the problem is?

Thanks
--
Ken Beard
MCSD, MCP

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.