SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Ells
Ells
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8859 Visits: 977
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.
palandri
palandri
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 114
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"
Ells
Ells
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8859 Visits: 977
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
Ells
Ells
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8859 Visits: 977
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
Lowell
Lowell
SSC Guru
SSC Guru (298K reputation)SSC Guru (298K reputation)SSC Guru (298K reputation)SSC Guru (298K reputation)SSC Guru (298K reputation)SSC Guru (298K reputation)SSC Guru (298K reputation)SSC Guru (298K reputation)

Group: General Forum Members
Points: 298353 Visits: 42177
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!
Attachments
Integration Services Script Task.jpg (40 views, 141.00 KB)
Ells
Ells
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8859 Visits: 977
Thanks Lowell.
I will have a look at that. Its less intrusive than uninstalling and reinstalling.

Cheers
M
Ells
Ells
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8859 Visits: 977
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search