SQL server SP3 installation problem

Recently, I installed SP3 for SQL server 2005. The installation went successful, but after the installation the maintenance plans were failing.

Problem: The maintenance jobs are failing after the SP3 installation on the test server.

Error Message: Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'.


Solution/Approach: This message is generally due to the unregistered COM in the dts.dll file in the \90\binn folder of the SQL server installation folder.

On Server follow below steps to fix the issue:

1. start -> run -> cmd
2. cd c:\Program Files\Microsoft SQL Server\90\DTS\binn
3. REGSVR32.EXE dts.dll

This fixes the issue !!