SSIS job are not runing and the job history shows an Error loading type library/DLL (NETIQKB72261)

  • 7772261
  • 27-Apr-2010
  • 05-Jan-2012

Environment

Directory & Resource Administrator/8.5 - DRA

NetIQ Reporting Center 1.X

Situation

SSIS job are not runing and the job history shows an Error loading type library/DLL

Resolution

To resove this you will need to Un-Register both 32Bit and 64Bit of Dts.dll and Un-Register both 32Bit and 64Bit of MsDtsSrvrUtil.dll and Re-Register both 32Bit and 64Bit of Dts.dll and both 32Bit and 64Bit of MsDtsSrvrUtil.dll "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll" "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\Ms DtsSrvrUtil.dll"

 

Cause

This problem occurs because the installer unregisters the 32-bit Dts.dll file when the installer installs the 64-bit Dts.dll file. The 64-bit Dts.dll file is installed together with SQL Server 2005 SP2. Additionally, the 64-bit Dts.dll file may be installed together with any SSIS hotfix package that contains the 64-bit Dts.dll file.

Additional Information

Formerly known as NETIQKB72261

For more information refer to the below Microsoft KB

http://support.microsoft.com/kb/919224