SSIS 2005 Description: Connect to SSIS Service on machine failed: Library not registered. Could not load package because of error 0xC00160AA.

After Applying Service Pack 4 to SQL Server 2005, I was unable to connect to SSIS from Management Studio.
I was also unable to run packages from the command line using DTEXEC.

Upon further investigation it see

c:\windows\system32\regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

c:\windows\system32\regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll”

  • 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.

The issue is described on Microsoft site in the following KB http://support.microsoft.com/kb/919224

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s