The ActiveX Scripting Host, used by all tasks that have ActiveX script capability, may become unregistered. This can lead to one of the errors below:

"ActiveX Scripting was not able to initialize the script engine."

"ActiveX Scripting Transform 'DTSTransformation__x' was not able to initialize the script engine."

"ActiveX scripting was not able to initialize the script execution engine"

Normally you can fix this by simply re-registering the DTS ActiveX Script Host DLL (axscphst.dll), using the Regsvr32.exe utility. If this does not solve the problem, then try re-registering the following DLLs in the same way: dtspkg.dll, dtspump.dll.

If you have installed SQL Server in the default location you may use the appropriate command below in the windows Run dialog or the command prompt:

Regsvr32.exe c:\mssql7\binn\axscphst.dll
(SQL Server 7.0)

Regsvr32.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll"
(SQL Server 2000)