Help and Support
 

powered byLive Search

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

Article ID:928324
Last Review:November 2, 2007
Revision:1.2
On This Page

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.

Back to the top

CAUSE

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

Back to the top

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.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

MORE INFORMATION

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.

Back to the top


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

Back to the top

Keywords: 
kbexpertiseadvanced kbtshoot kbsql2005ssis kbprb KB928324

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.