I have a DTS package, that executes an ActiveX script. The ActiveX script
issues the following command:

iRetVal = wshShell.Run (sCmdLine, 1,TRUE). The sCmdLine is a valid DTSRUN
statement.

At this point, a Command Prompt window appears and then disappears quickly,
and the DTS package fails. Examination of the package log indicates the
following error code: -2147220421

When this job is run from the scheduler with SA as the owner, the job runs
fine. I used to be able to execute the package in question without any
problem, until my PC was upgraded to WinXP SP2. Prior to that I was on WinXP
SP1 and I had SS2K SP3 client tools installed on my PC. For the previous
installation, I was a local administrator for my PC, and I connected to all
my servers based on Windows Authentication.

As I mentioned, my current installation is WinXP XP2. I am also running
SS2K SP4. However, I am no longer a Local Administrator for my PC, and the
SQL Server client tools were installed by someone else. I still connect to
all our SQL Servers via Windows Authentication, and I can still run any DTS
package, as long as the package does not have an ActiveX script that issues a
WshShell.Run command.

What do I need to do to be able to run my packages again?