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 Server90DTSBinnDTS.dll”

Regsvr32 /u “C:Program FilesMicrosoft SQL Server90DTSBinnDTS.dll”

Regsvr32 /u “C:Program Files (x86)Microsoft SQL Server90dtsBinnMsDtsSrvrUtil.dll”

Regsvr32 /u “C:Program FilesMicrosoft SQL Server90dtsBinnMsDtsSrvrUtil.dll”

Regsvr32 /u “C:Windowssystem32msxml6.dll”

Regsvr32 /u “C:WindowsSysWOW64msxml6.dll”

Regsvr32 /u “C:Windowssystem32msxml6.dll”

Regsvr32 /u “C:WindowsSysWOW64msxml6.dll”

ECHO ‘Re-registering Dlls ‘

Regsvr32 “C:Program Files (x86)Microsoft SQL Server90DTSBinnDTS.dll”

Regsvr32 “C:Program FilesMicrosoft SQL Server90DTSBinnDTS.dll”

Regsvr32 “C:Program Files (x86)Microsoft SQL Server90dtsBinnMsDtsSrvrUtil.dll”

Regsvr32 “C:Program FilesMicrosoft SQL Server90dtsBinnMsDtsSrvrUtil.dll”

Regsvr32″C:Windowssystem32msxml6.dll”

Regsvr32″C:WindowsSysWOW64msxml6.dll”

Regsvr32 “C:Windowssystem32msxml6.dll”

Regsvr32 “C:WindowsSysWOW64msxml6.dll”