SQL Server error 22022 -SSIS Syssubsystme could not found ..
SELECT subsystem ,subsystem_dll
FROM msdb..syssubsystems
UPDATE msdb..syssubsystems
SET subsystem_dll = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQL1\MSSQL\Binn\SQLDTSSS.DLL'
WHERE subsystem = 'SSIS'
D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\binn\SQLDTSSS.DLL
During the server rebuild, the SQL Server program files where installed under the C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQL1\MSSQL\Binn\ directory whereas on the crashed server installation, all the old binaries were installed under D:\Program Files\. Since we restored the MSDB database from an old backup, those values overwrote the values from the new sqlr install.
