Home Forums SQL Server 2012 SQL 2012 - General SSIS - create a script task programatically (the binary code for the script is not found) RE: SSIS - create a script task programatically (the binary code for the script is not found)

  • May 7, 2014 at 2:32 pm

    #1711697

    marcelo.negrisoli (5/7/2014)

    Hi,

    I wrote a script task that´s build a SSIS Package dynamically with a Script Task.

    When I open this dynamically created package, the Script Task shows with error and "the binary code for the script is not found" message.

    But, when I open the Script Task, closes and click "Ok", the error disappears ...

    Is there a way to fix this, without needs to open in BIDS ?

    This is the reference to dinamically script task:

    http://stackoverflow.com/questions/18611319/set-script-task-code-dynamically-in-ssis-2012

    Thanks and sorry my broken english :ermm:

    The ScriptingEngine.SaveProjectToStorage() wasn't successful, it writes the binary script code to the package, and the error message says that it's missing.

    I did solve this by saving the package to a file/db storage and reload it before execution.

    😎