I am using SQL 2005 Failover Cluster and I use Windows Scheduled Task to execute my DTS packages.
My batch files use dtsrun and sqlcmd.
In the active node, every things OK.
However, when I fail over to the passive node, and executed the batch files manually (they locate at the SAN disk, of course).
It displayed :
DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error=-2147220487 (800403F9)
Error string : ActiveX Scripting was not able to initialize the script execution engine.
I have already read the following web sites and re-registierd the following DLL with Regsvr32 :
AXSCPHST90.dll, DTSPkg.dll, DTSPump.dll
Please help me, thanks.