Date: 03/22/07 (SQL Server)    Keywords: sql, web

SQL2K.

I'm trying to call a DTS package from a stored procedure. I get the following error:

Error string: ActiveX Scripting was not able to initialize the script execution engine.

The package runs correctly when I run it straight from Enterprise Manager.
I have reregistered the DLLs suggested in the solution at sqldts.com and get the same error.
I've pulled out all the variables and distilled the command to:

EXEC master..xp_cmdshell 'DTSRun /S "EDISON" /U "sa" /P "--------" /N "VariablePassTest"

...and I still get the error.

(The package at present contains nothing but an activex script task whose only line of substance is a messagebox displaying the value of the passed variable.)

Anyone know of any alternative reasons why this error would appear? The Intarwebz are being somewhat unhelpful, as everything seems to point back to re-registering the DLLs. TIA.

Source: http://community.livejournal.com/sqlserver/57176.html