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"

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

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