Post reply

Visual Studio New Script Task always Errors - Scripts contained in the package have compilation errors ......

  • December 7, 2018 at 5:26 am

    #378785

    All the info of what I have is below at the bottom. Basically VS 2015 pro. I have had several versions of SQL installed before VS2015 including SSDT.
    I have noticed every time I edit a script task now it will raise an error. So I created a new package, added a new script task, I clicked ‘Edit  Script’ to open the script task editor. Then if I close the editor I get an error message. ‘Scripts contained in the package have compilation errors. Do you want to save changes?’
    This happens every time!!! If I open a previously ok script task and close it then we get the same message

    Hope you can help (withous suggesting all software removed and reinstalled)

    Cheers
    M

    Microsoft Visual Studio Professional 2015
    Version 14.0.23107.0 D14REL
    Microsoft .NET Framework
    Version 4.6.01055

    Installed Version: Professional

    LightSwitch for Visual Studio 2015   00325-60001-73525-AA100
    Microsoft LightSwitch for Visual Studio 2015

    Microsoft Visual Studio Tools for Applications 2015   00325-60001-73525-AA100
    Microsoft Visual Studio Tools for Applications 2015

    Visual Basic 2015   00325-60001-73525-AA100
    Microsoft Visual Basic 2015

    Visual C# 2015   00325-60001-73525-AA100
    Microsoft Visual C# 2015

    Visual C++ 2015   00325-60001-73525-AA100
    Microsoft Visual C++ 2015

    Visual F# 2015 RC   00325-60001-73525-AA100
    Microsoft Visual F# 2015 RC

    Application Insights Tools for Visual Studio Package   1.0
    Application Insights Tools for Visual Studio

    ASP.NET and Web Tools   14.0.20626.0
    ASP.NET and Web Tools

    ASP.NET Web Frameworks and Tools 2013   5.2.30624.0
    For additional information, visit http://www.asp.net/

    Common Azure Tools   1.5
    Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

    GenerateUnitTest   1.0
    Generates unit test code for methods in classes under test.

    Microsoft Azure Mobile Services Tools   1.4
    Microsoft Azure Mobile Services Tools

    NuGet Package Manager   3.0.0
    NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

    Office Developer Tools for Visual Studio 2015 ENU   14.0.23025
    Microsoft Office Developer Tools for Visual Studio 2015 ENU

    PreEmptive Analytics Visualizer   1.2
    Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

    SQL Server Analysis Services   13.0.1701.8
    Microsoft SQL Server Analysis Services Designer
    Version 13.0.1701.8

    SQL Server Data Tools   14.0.61021.0
    Microsoft SQL Server Data Tools

    SQL Server Integration Services  
    Microsoft SQL Server Integration Services Designer
    Version 13.0.1601.5

    SQL Server Reporting Services   13.0.1701.8
    Microsoft SQL Server Reporting Services Designers
    Version 13.0.1701.8

    Workflow Manager Tools 1.0   1.0
    This package contains the necessary Visual Studio integration components for Workflow Manager.

  • December 7, 2018 at 8:39 am

    #2015777

    Several folks that have encountered this error found it started occurring after a VS update.

    Google this, and take a look at the first several hits:

    ssis "Scripts contained in the package have compilation errors"

  • December 7, 2018 at 8:58 am

    #2015779

    Yep,
    been through a couple of those. The first one seemed closest to my issue added the ComVisble(false) but that seems top be a red herring.

    Everyone else is uninstall and reinstall which in a corporate client may take several weeks so dont want to try that and find out it does not work.

    Thanks
    M

  • December 7, 2018 at 9:01 am

    #2015780

    The more I look the more I see dead ends with this issue. 

    I wonder if there has been an update or even going to 2015 Pro started this

    Thanks
    M

  • December 7, 2018 at 3:16 pm

    #2015807

    any chance you edited the Script task template itself?
    i got the same error, but I knew it was me.
    i edited the template for Visual Studios C# Script task, so that the main function was not so generic, but had a proper try{}catch{} block and a few other trivial enhancements.

    eve though i used a darn good text editor, and saved it with syntax correct and everything, i got the same error as you...i ended up having to revert back to the original template, and had to give up on customizing it to my liking.

    your error seems so similar, i would recommend replacing the templates from another machine and see if that fixes it.
    in my old example, i was opening this zip, i think, editing the ScriptMain.cs:
    i was doing something wrong, whether i used the wrong zip utility to re-zip, or something else crross checks the contents, it onyl worked halfway for me.

    C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ProjectTemplates\CSharp\SSIS_ScriptTask\1033\Integration Services Script Task.zip

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 10, 2018 at 1:17 am

    #2015849

    Thanks Lowell.
    I will have a look at that. Its less intrusive than uninstalling and reinstalling.

    Cheers
    M

  • December 10, 2018 at 3:51 am

    #2015854

    As an update. No longer think its the script template. My reason is I can open a VB Script task and same thing happens so both templates would need to be corrupted. So I went for applying Update 3

    Started with 
    Microsoft Visual Studio Professional 2015
    Version 14.0.23107.0 D14REL
    Microsoft .NET Framework
    Version 4.6.01055

    Now on
    Microsoft Visual Studio Professional 2015
    Version 14.0.25431.01 Update 3
    Microsoft .NET Framework
    Version 4.6.01055

    So update 3 appears to have fixed this issue.

    Many Thanks
    M

Viewing 7 posts - 1 through 6 (of 6 total)

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