SQL Server 2005 DTS wizard 无法运行，微软SQL Server 2005的升级包实在是差劲呀！

今天升级了SQL Server 2005 Sp3。升级后发现DTS无法运行了。出错提示为“Unable to cast COM object of type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface
type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This
operation failed because the QueryInterface call on the COM component for the
interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the
following error: Interface not registered (Exception from HRESULT:
0x80040155). (Microsoft.SqlServer.DTSRuntimeWrap) ... "

 

经过查找发现原来是DTS COM对象没有注册成功。

运行regsvr32 "C:/Program Files/Microsoft SQL Server/90/DTS/Binn/dts.dll"后DTS运行正常了。

微软SQL Server 2005的升级包实在是差劲呀。