Monday, March 8, 2010

Maintainance Plan -- Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

When editing a maintenance plan (that I am newly creating) I got:
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
The issue is the client tools installed in %ProgramFiles(x86)% instead of %ProgramFiles% but instead of reinstalling client tools, I ran:

%windir%\syswow64\regsvr32 "D:\MSSQL (x86)\90\DTS\Binn\dts.dll"
which resolved the issue.

No comments: