locked
Version Exception on C# Script Task RRS feed

  • Pergunta

  • We are getting the following error when attempting to schedule and run a SSIS Package on our Production Job Server.

    Source: Script Task - C# To Determine File Size for Control File Script Task - C# To Determine File Size for Control File     Description: There was an exception while loading Script Task from XML: System.Exception: The Script Task "ST_d2eaec3757c64bbe937ea17da8a504e3" uses version 15.0 script that is not supported in this release of Integration Services. To run the package, use the Script Task to create a new VSTA script. In most cases, scripts are converted automatically to use a supported version, when you open a SQL Server Integration Services package in %SQL_PRODUCT_SHORT_NAME% Integration Services.     at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj, IDTSInfoEvents events)  End Error  Error: 2020-08-15 04:00:05.09     Code: 0x00000003     Source: Script Task - C# To Determine File Size for Control File      Description: The Script Task is corrupted.  End Error  Error: 2020-08-15 04:00:05.09     Code: 0xC0024107     Source: Script Task - C# To Determine File Size for Control File      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  4:00:00 AM  Finished: 4:00:05 AM  Elapsed:  4.203 seconds.  The package execution failed.  The step failed.

    Is this merely a change to the Project within Microsoft Visual Studio and Configuration Properties/General

    And changing the TargetServerVersion  to SQL Server 2016 or  it erroring on the C# Edit Task is it something deeper, more complex than that?

    This SSIS Package runs fine locally on my client machine. Just errors out when running it from our Production Job Server.

    Thanks for your review and am hopeful for a reply.

    sábado, 15 de agosto de 2020 09:49

Todas as Respostas

  • Hi ITBobbyP,

    In VS you need to do two things:

    • Set the TargetServerVersion  to SQL Server 2016, to match run-time SSIS version on the server.
    • Open Script Task and select Build in the menu, make sure it compiles without any errors.in VS.

    On the SSIS server side:

    • Make sure the same .Net Framework version that is used by the Script Task is installed.



    domingo, 16 de agosto de 2020 01:05
  • Hi ITBobby,

    May I know the version of SQL Server in your Production Job Server?

    Please change the TargetServerVersion of the ssis package locally.

    Then execute the package in the job.

    The following link will be helpful:

      SSIS Version 15.0 Script Error

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    segunda-feira, 17 de agosto de 2020 02:18