DTS to SSIS Migration

  • Hi All,

    While i'm migrate from dts package to ssis package. ActiveX Scripting transform was not able to initialise the script execution engine. I am a beginer's of ssis package. If possible, Could you pls

    suggest me, how to fix it. Its very urgent.

    And I have copied those error message which i got it.

    Error Msg:

    Step Error Description: ActiveX Scripting Transform 'DTSTransformation_18 was not able to initialize the scripting execution engine.

  • You basically have to rewrite it. Scripts are one of the things that the upgrade wizard doesn't really do anything with.

    Sorry.

    Also, did you get an SSIS package with an EXEC SQL 2000 package component or what?

    CEWII

  • You basically have to rewrite it. Scripts are one of the things that the upgrade wizard doesn't really do anything with.

    [p]I accept. And you can use Script Task instead of ActiveX Script components.[/p]

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

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

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