Home > Archive > MS SQL Server DTS > January 2006 > Unable to load DTS within SQL 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Unable to load DTS within SQL 2005
Ken Beard

2006-01-26, 4:58 pm

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.LegacyActionBase. CreateLegacyDesigner
()
at
Microsoft.SqlServer.Dts.ObjectExplorerUI. OpenLegacyPackageAct
ion. Act(INodeInformation
nodeInfo)
at
Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem. Invoke(INodeInformat
ion 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
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com