This KB article will be released shortly an available via http://support.microsoft.com/kb/929390
When the SystemCenterDTSPackageTask scheduled task runs on a computer that is running Microsoft Operations Manager (MOM) 2005 Reporting, the task is not completed successfully. In this scenario, the following event is logged in the Application log: Event Type: Error Event Source: MOM.Datawarehousing.DTSPackageGenerator.exe Event Category: None Event ID: 1001 Date: dateTime: timeUser: N/A Computer: ReportingServerDescription: An error occurred while generating the DTS package. Catastrophic failure
This problem occurs if one of the following System Center reporting files is corrupted:
By default, these files are located in the %ProgramFiles%\Microsoft System Center Reporting\Reporting folder.
To resolve this problem, follow these steps:
The three DTS package files that are mentioned in this article are created every time that the SystemCenterDTSPackageTask scheduled task runs. Also, these three files are deleted when this scheduled task finishes. If one of the DTS package files are corrupted, the DTS package is not generated when the SystemCenterDTSPackageTask scheduled task runs. Therefore, the DTS operation is unsuccessful.The SystemCenterDTSPackageTask job is located under the Scheduled Tasks item in Control Panel. The executable path of this schedule task is set to the following path:
ExecutablePath=driveletter:\Program Files\Microsoft System Center Reporting\Reporting\MOM.Datawarehousing.DTSPackageGenerator.exe
To obtain the error information output directly from the MOM.Datawarehousing.DTSPackageGenerator.exe program, paste the DTS command-line information in a Command Prompt window. For example, follow these steps:
%ProgramFiles%\Microsoft System Center Reporting\Reporting
MOM.Datawarehousing.DTSPackageGenerator.exe /silent /srcserver:servername /srcdb:OnePoint /dwserver:servername /dwdb:SystemCenterReporting /product:"Microsoft Operations Manager"
Replace servername with the name of the computer that hosts the MOM 2005 database.
If the DTS job fails, error information is generated at the command prompt. You can redirect this output to a text file to help troubleshoot the failure of the DTS job. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
899158 How to troubleshoot DTS and database sizing issues in MOM 2005 Reporting
Hello. I was looking for SystemCenterReporting and found this article. I am actually looking for how to restore the SystemCenterReporting database if that is possible. Any information will be greatly appreciated.