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:
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:
- On the SQL Server 2005 setup media, run the Setup.exe file.
- On the Components to Install page, click Advanced.
- On the Feature Selection page, expand Client Components, click Legacy Components, and then click Will be installed on local hard drive.
- 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 "Applies to" section.
MORE INFORMATION
Steps to reproduce the problem
- On a computer that has SQL Server 2000 DTS installed, create a DTS package.
- Add the ActiveX Script task to the DTS package, and then save the DTS package.
- Install SQL Server 2005 Integration Services on the computer.
- Use the dtsrun command prompt utility (Dtsrun.exe) to run the DTS package.
Keywords: kbexpertiseadvanced kbtshoot kbsql2005ssis kbprb KB928324
