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

  • Document ID:7772261
  • Creation Date:27-Apr-2010
  • Modified Date:05-Jan-2012
    • Micro Focus Products:
      Directory and Resource Administrator

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