Microsoft KB Archive/928324

= Error message when you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package in SQL Server 2005 Integration Services: &quot;This application has failed to start because SQLResourceLoader.dll was not found&quot; =

Article ID: 928324

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Personal Edition
 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
Consider the following scenario. On a computer that has Microsoft SQL Server 2000 Data Transformation Services (DTS) installed, you install Microsoft SQL Server 2005 Integration Services. Then, you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package that contains the ActiveX Script task. In this scenario, you receive the following error message:

DTSRun.exe Unable to Locate Component

This application has failed to start because SQLResourceLoader.dll was not found. Re-installing the application may fix this problem.



CAUSE
This problem occurs because the SQLResourceLoader.dll file is not installed on the computer.



RESOLUTION
To resolve this problem, install the Legacy Components feature from the SQL Server 2005 setup media. To do this, follow these steps:
 * 1) On the SQL Server 2005 setup media, run the Setup.exe file.
 * 2) On the Components to Install page, click Advanced.
 * 3) On the Feature Selection page, expand Client Components, click Legacy Components, and then click Will be installed on local hard drive.
 * 4) Click Next, and then complete the SQL Server Installation Wizard.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the problem

 * 1) On a computer that has SQL Server 2000 DTS installed, create a DTS package.
 * 2) Add the ActiveX Script task to the DTS package, and then save the DTS package.
 * 3) Install SQL Server 2005 Integration Services on the computer.
 * 4) Use the dtsrun command prompt utility (Dtsrun.exe) to run the DTS package.

Keywords: kbexpertiseadvanced kbtshoot kbsql2005ssis kbprb KB928324

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.