Problems with ActiveX using DTS's in SQLServer2008

  • Hi there,

    For "some reason" we' re still using DTS's and now we have migrated all system to SQLServer2008. We could configurated this server to import DTS's (legacy) but when we try to execute an ActiveX Task, appears this:

    Error Source: Microsoft Data Trasformation Services (DTS)

    Error Description: ActiveX Scripting was no able to initialize the script execution engine

    We have checked in some forums that the AXSCPHST.DLL have to be registered, but even we try (using regsvr32) we can't.

    Any kind of help are welcome

    Server Details: Windows Server 2008 R2 Standard SP1 64bit, SQLServer2008 64bits.

  • What is your ActiveX script doing? Evaluate whether you're running into an issue because the DTS pkg is trying to load a 32-bit binary into a 64-bit process.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Well, we use it to access to some app functions (*.dll), but even we create a simple ActiveX Task that says 'Hello World' in a message, doesn't work.

  • any ideas ?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply