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.

  • Really ? ... I don't understand why not if you can use the rest of features and/or objects that come into a DTS Package Designer plus you can select an ActiveX Task, anyway Im gonna try to do the update to SSIS Packages.

    Thanx

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

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