?
Solved

ActiveX Scripting Transform 'DTSTransformation__11' was not able to initialize the script execution engine.

Posted on 2014-07-15
1
Medium Priority
?
1,112 Views
Last Modified: 2015-03-11
We migrated our backup exec database from SQL Express to SQL 2008 R2 on the same server.  yes we had both SQL Express and SQL 2008 R2 installed on the same server.  We also have the DTS components and backwards compatibility components installed so that we can run DTS packages in 2008 R2.  All of this was working perfectly until last night after the database migration.  I don't know why backup exec would mess with SQL DLLs it was just supposed to move the data to a different SQL instance but  now one of our SQL jobs fails with this error.  I have googled this and found stuff like this about reregistering the DLL but as far as I can tell this file does not exist in the BINN folder but rather in the 100/COM folder and it is already registered. I unregistered and reregistered it and still not working.  Any ideas on how to fix this ActiveX Script Execution engine on SQL 2008 R2?

DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  DTSStep_DTSDataPumpTask_2   DTSRun OnError:  DTSStep_DTSDataPumpTask_2, Error = -2147213242 (80042046)      Error string:  ActiveX Scripting Transform 'DTSTransformation__11' was not able to initialize the script execution engine.      Error source:  Microsoft Data Transformation Services (DTS) Data Pump      Help file:  sqldts80.hlp      Help context:  30631      Error Detail Records:      Error:  -2147213242 (80042046); Provider Error:  0 (0)      Error string:  ActiveX Scripting Transform 'DTSTransformation__11' was not able to initialize the script execution engine.      Error source:  Microsoft Data Transformation Services (DTS) Data Pump      Help file:  sqldts80.hlp      Help context:  30631      DTSRun OnFinish:  DTSStep_DTSDataPumpTask_2   DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.
0
Comment
Question by:NBF
1 Comment
 

Accepted Solution

by:
NBF earned 0 total points
ID: 40197092
Running all 3 of these in this order seemed to do it.  

regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll"
regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\dtspump.dll"
regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\COM\AXSCPHST.DLL"

AXSCPHST.DLL was not in the 80\tools\binn folder anywhere.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question