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)