Error message that is displayed by the ProcessDWJob SQL Server Agent job in System Center Reporting Services 2006: "The system cannot find the file specified" (918009)


The information in this article applies to:

  • Microsoft System Center Reporting Manager 2006 English (United States)

SYMPTOMS

You troubleshoot unsuccessful synchronizations from Microsoft Systems Management Server (SMS) 2003 in Microsoft System Center Reporting Manager (SCRM) 2006. When you view the job history of the ProcessDWJob SQL Server Agent job in Microsoft SQL Server 2005, you notice that the job displays the following error message:
The system cannot find the file specified.

CAUSE

This issue occurs if the SQL Server 2005 Legacy Components were not installed with SQL Server 2005.

RESOLUTION

To resolve this issue, run the SQL Server 2005 Setup program to install the Legacy Components client component. To do this, follow these steps:
  1. Click Start, point to Control Panel, and then click Add or Remove Programs.
  2. In the Currently installed programs list, click Microsoft SQL Server 2005, and then click Change.
  3. In the Microsoft SQL Server 2005 Maintenance dialog box, click Workstation Components, and then click Next >.
  4. In the Microsoft SQL Server 2005 Setup dialog box, click Next >.
  5. On the System Configuration Check page, click Next.
  6. Click Change Installed Components, expand Client Components, click Legacy Components, and then click Will be installed on local hard drive.
  7. Click Next >, and then follow the steps to finish installing SQL Server 2005.

MORE INFORMATION

When the ProcessDWJob runs, it uses the DTSRun.exe program to start the data transformation services (DTS) jobs that import data into the SCRM database. This process occurs after the data has been extracted from SMS 2003, and then transferred to the SCRM server by the SMS data source server. If the ProcessDWJob fails, the data is not imported into the SCRM database. Therefore, the SMS data is not available for reporting in SCRM. When the SQL Server 2005 Legacy Components are installed, Dtsrun.exe is installed in the following folder:

%ProgramFiles%\Microsoft SQL Server\80\Tools\Binn

Modification Type:MajorLast Reviewed:5/24/2006
Keywords:kbtshoot kbDeployment kberrmsg kbprb KB918009 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.