Deploying SSIS for SQL Server 2016

I have an SSIS project in VS:

Microsoft Visual Studio Professional 2015 Version 14.0.25431.01 Update 3 Microsoft.NET Framework Version 4.6.01590 SQL Server Data Tools 14.0.61116.0 Microsoft SQL Server Data Tools SQL Server Integration Services Microsoft SQL Server Integration Services
Designer Version 13.0.1601.5

Project> Properties> Configuration Properties> Target Deployment Version> TargetServerVersion = SQL Server 2016

I turned around and successfully passed the test on two instances of SQL Server, but I can not on the third.

The main difference that I see in three cases:

First (success)

Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) July 5, 2017 11:41:17 PM Copyright (c) Microsoft Developer Edition (64-bit) for Windows Server 2012 R2 Datacenter 6.3 ( build 9600 :) (hypervisor)

Second (success)

Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) July 5, 2017 11:41:17 PM Copyright (c) Microsoft Developer Developer Edition (64-bit) on Windows Server 2012 Datacenter 6.2 (Build 9200 :) (Hypervisor)

Third (unsuccessful)

Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64) September 5, 2017 16:12:34 Copyright (c) Microsoft Corporation Enterprise Edition: kernel-based licensing (64-bit) on Windows Server 2012 R2 Datacenter 6.3 (Build 9600 :) (hypervisor)

Google, , , SQL Server 2014. , , - Sql (, , Enterprise -, ), .

: enter image description here

+1
1

, , Visual Studio , . , , SQL Server Visual Studio ( , Windows).

, SSDT (Visual Studio 2015) . , , , SSDT , ( Git).

, Microsoft ... , SSDT Visual Studio 2017.

+1

Source: https://habr.com/ru/post/1625074/


All Articles