SSIS: script task (vs15) does not work when deploying to sql 2014 server

Question

Mistake:

There was an exception while loading Script Task from XML: System.Exception: Script task uses version 14.0 of Script, which 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 automatically converted to use a supported version when you open the SQL Server Integration Services package in% SQL_PRODUCT_SHORT_NAME% integration services. in Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML (XmlElement elemProj, IDTSInfoEvents events)

I do exactly what he says, but it doesn’t help.

Any solution?

Answer 1

The revised version of SSDT (now 14.0.61x) has a fix.

• Install the new version. ( SSDT For Download )

• Right-click the project> "Properties"> "Configuration Properties"> "General"> "TargetServerVersion" - "Update to SQL Server 2014"> "Retry".

Answer 2

This worked for me:

• Install SSDT-BI for Visual Studio 2013.
• Open your solution in Visual Studio 2015.
• Select an SSIS project in Solution Explorer.
• From the Project menu, select Properties.
• In the Property Pages dialog box, select Configuration Properties → General
• " " "SQL Server 2014".
• .

Answer 3

, , , :

• SSIS SQL Server 2014
• script
• SQL Server 2014
• " script 15.0 script, Integration Services..."

:

• VS2015 3
• SSDT v 17.1
• SSMS v17.1

SSDT 17.1 SQL Server 2014 - SQL Server vNext. SSDT , , .

, SSIS , :

• VS 2015 ( SSIS → → )
• SSIS SQL Server 2014 (, , , Windows Microsoft SQL Server 2014)

SQL Server Management Studio v17.1 SSIS, . script 15.0, SQL Server 2014.

SSIS Microsoft SQL Server vNext CTP2.0. "" Windows, , , SSMS 17.1, script .

:

• SSDT v17.1 VS2015 , .
• Visual Studio 2015
• SSIS
• If you are using the latest SSMS v17.1 and the integrated SSIS Deployment Wizard, the SSIS script package The task will not be completed on the target server to upgrade to SQL Server 2017.

It may be by design, but it is very confusing and caught me on guard. Just in case, this is a mistake. I sent an error report .