swapnil_mohile
asked on
ActiveX scripting transform not able to initialize script execution engine
I have DTS package which uses a simple activex script transformation. The DTS package runs fine from the Enterprise manage from the server machine or any client machine.
I have VB exe which calls the DTS package and when run it returns an error saying the ActiveX scripting transform not able to initialize script execution engine.
The machine where the exe runs doesnt have SQL client installed. It has the following Dll registered
axscphst.dll, dtsffile.dll, dtspkg.dll, dtspump.dll
Can anybody help me out on this probably a solution that doesnt require sql client to be installed
I have VB exe which calls the DTS package and when run it returns an error saying the ActiveX scripting transform not able to initialize script execution engine.
The machine where the exe runs doesnt have SQL client installed. It has the following Dll registered
axscphst.dll, dtsffile.dll, dtspkg.dll, dtspump.dll
Can anybody help me out on this probably a solution that doesnt require sql client to be installed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then you are missing a step. The answer is there. In particular it is an enhancement to what is already covered in the SQL Server Readme. The problem is that most people don't read the Readme.
ASKER
Have managed to solve the issue. Basically i guess there was some version issue. All the dlls were not of the same version. I unregistered all dlls and registered all the mentioned dll which were of the same version.
ASKER