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