Problems with SSIS on Itanium based or x64 servers

Problems with SSIS on Itanium based or x64 servers. On the company cluster tlasrv48 i had this error:

Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)) (Microsoft.SqlServer.DTSRuntimeWrap)

The solution to fix this problem is to reregister some dll files:

ECHO ‘Un-registering Dlls ‘

Regsvr32 /u “C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

Regsvr32 /u “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

Regsvr32 /u “C:\Program Files (x86)\Microsoft SQL Server\90\dts\Binn\MsDtsSrvrUtil.dll”

Regsvr32 /u “C:\Program Files\Microsoft SQL Server\90\dts\Binn\MsDtsSrvrUtil.dll”

Regsvr32 /u “C:\Windows\system32\msxml6.dll”

Regsvr32 /u “C:\Windows\SysWOW64\msxml6.dll”

Regsvr32 /u “C:\Windows\system32\msxml6.dll”

Regsvr32 /u “C:\Windows\SysWOW64\msxml6.dll”

ECHO ‘Re-registering Dlls ‘

Regsvr32 “C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

Regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

Regsvr32 “C:\Program Files (x86)\Microsoft SQL Server\90\dts\Binn\MsDtsSrvrUtil.dll”

Regsvr32 “C:\Program Files\Microsoft SQL Server\90\dts\Binn\MsDtsSrvrUtil.dll”

Regsvr32″C:\Windows\system32\msxml6.dll”

Regsvr32″C:\Windows\SysWOW64\msxml6.dll”

Regsvr32 “C:\Windows\system32\msxml6.dll”

Regsvr32 “C:\Windows\SysWOW64\msxml6.dll”

Advertisements
%d bloggers like this: