问题描述:

The error:

There was an exception while

loading Script Task from XML: System.Exception: The Script Task

uses version 14.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)

I'm doing exactly what it says, but it does not help.

Any solution?

网友答案:

This worked for me:

  1. Install SSDT-BI for Visual Studio 2013.
  2. Open your solution in Visual Studio 2015.
  3. Select your SSIS Project in the Solution Explorer.
  4. In the Project menu select Properties.
  5. In the Property Pages dialog select Configuration Properties -> General
  6. Under Deployment Target Version change the Target Server Version to "SQL Server 2014."
  7. Clean and rebuild solution and redeploy.
网友答案:

You need to use Visual Studio 2012 or 2013 to create SSIS packages for SQL Server 2014.

Visual Studio 2015 will create SSIS packages that are only compatible with SQL Server 2016.

网友答案:

In the revised version of the SSDT (now 14.0.61x), there is a fix.

  1. Install new version. (SSDT For download)

  2. Right click project > Properties > Configuration Properties > General > TargetServerVersion - Update to SQL Server 2014 > Redeploy.

相关阅读:
Top