Error In Log: 2008-08-22 00:30:00 - ! [LOG] Step 1 of job 'WWE_Live_EventsImporter' (0x02221292890280428E3B425FD9657674) cannot be run because the SSIS subsystem failed to load. The job has been suspended\
When you change servers and restore msdb/Attached old MSDB database, you may find your SSIS Packages/Maintenance plans failing and putting the following messages into various logs:
* The SSIS subsystem failed to load* Subsystem could not be loaded* The job has been suspended* The specified module could not be found
The problem is most likely that the location of your SQL Server installation directory differs from the entries in msdb table syssubsystems. As SQL Server keeps a table of pointers to the SSIS DLLs in msdb, we need to flush this table and repopulate it with the new locations (KB article 914171)
SELECT * FROM msdb.dbo.syssubsystems
Result:
SubSystem_DLL Path : D:\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL
Check the Actual path for this DLL file, if it is differ then below is the method to fix this:
-- Delete the existing rows.DELETE FROM msdb.dbo.syssubsystems
-- Fill the table with new rows pointing to the proper location of the DLLs.
EXEC msdb.dbo.sp_verify_subsystems 1
Restarted SQL Server Agent for it to pick up the new table entries and unsuspend the SSIS jobs.KB Article for Reference: http://support.microsoft.com/kb/914171
I am related to Software Industry working as SQL Database Administrator, so I have created this blog to collect useful information about my area of work. It may contains references to stuff published somewhere else on internet [with full regards to the publisher, of course] and also some of my own. I will also post some out of the box stuff too, if I find it interesting.
No comments:
Post a Comment