Connect to SSIS service on machine <Machine Name> failed: Error loading type library/DLL | SansSQL

Tuesday, November 12, 2013

Connect to SSIS service on machine failed: Error loading type library/DLL

When connecting to an SSIS instance on a newly installed system you might be sometimes presented with the error "Connect to SSIS service on machine <Machine Name> failed: Error loading type library/DLL"


This problem occurs if one of the following conditions is true:
  • The SQL Server 2005 Integration Services hotfix package is installed. However, the SQL Server 2005 Tools hotfix package is not installed.
  • You install the SQL Server 2005 Tools hotfix package before you install the SQL Server 2005 Integration Services hotfix package.
  • You are running two instances of SQL Server 2005 on the computer. Additionally, the versions of both instances of SQL Server are earlier versions than Microsoft SQL Server 2005 Service Pack 2 (SP2).
  • The computer is running an instance of SQL Server 2005 with SP2. Additionally, you install a post-SP2 hotfix on this instance. Then you install a second instance of SQL Server 2005. On the second instance, you install SQL Server 2005 SP2.
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.

Resolution:
Manually Register the DTS dll's files
  1. Go to command prompt (Start --> Run --> Cmd)
  2. Type "cd c:\windows\system32" and hit enter
  3. Registering 64-bit version dlls
    regsvr32 "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dts.dll"
    regsvr32 "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll"
  4. Registering 32-bit version dlls
    regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dts.dll"
    regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll"

1 comment:

Peter Thompson said...

A useful post. When I'm having similar problems, I know how to deal with them. Reinstall the software or operating system, always helps :) And recently, I was advised to download the new dll files http://fix4dll.com/kernel32_dll. I have not tried, but kept the link for myself, maybe it will be easier than reinstalling :)

Post a Comment