将SSIS包部署到SQL Server 2016 [英] Deploying SSIS Package to SQL Server 2016
问题描述
我在VS中有一个SSIS项目：
I have an SSIS project in VS:
Microsoft Visual Studio Professional 2015
版本14.0.25431.01更新3
Microsoft .NET Framework
版本4.6.01590
SQL Server数据工具14.0.61116.0
Microsoft SQL Server数据工具
SQL Server集成服务
Microsoft SQL Server集成服务设计器
版本13.0.1601.5
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
项目>属性>配置属性>部署目标版本> TargetServerVersion = SQL Server 2016
Project > Properties > Configuration Properties > Deployment Target Version > TargetServerVersion = SQL Server 2016
我已在两个SQL Server实例上成功部署并验证，但在第三个SQL Server实例上未成功。
I deployed and validated successfully on two SQL server instances, but cannot on a third.
我在这三种情况下看到的主要区别是：
The chief difference I see in the three instances is this:
第一个（成功）
Microsoft SQL Server 2016（RTM-GDR）（KB4019088）-13.0.1742.0（X64）
2017年7月5日23:41:17
版权所有（c）Microsoft Corporation
开发人员版（ 6 Windows Server 2012 R2 Datacenter 6.3（内部版本9600：）（管理程序）上的4位）
Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) Jul 5 2017 23:41:17 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 (Build 9600: ) (Hypervisor)
第二个（成功）
Microsoft SQL Server 2016（RTM-GDR）（KB4019088）-13.0.1742.0（X64）2017年7月5日23:41:17版权所有（c）Microsoft Corporation Developer Edition（64位）在Windows Server 2012 Datacenter 6.2（内部版本9200：）（系统管理程序）上
Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) Jul 5 2017 23:41:17 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2012 Datacenter 6.2 (Build 9200: ) (Hypervisor)
第三（失败）
Microsoft SQL Server 2016（SP1-CU5）（KB4040714）-13.0.4451.0（X64）2017年9月5日16:12:34版权所有（c）Microsoft Corporation Enterprise Edition：基于核心的许可（64位）在Windows Server 2012 R2 Datacenter 6.3（内部版本9600：）（系统管理程序）上
Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64) Sep 5 2017 16:12:34 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Datacenter 6.3 (Build 9600: ) (Hypervisor)
我一直无法通过Google跟踪错误的修复程序，它们似乎是与我以SQL Server 2014为目标时的情况相同。如有必要，我可以将其发布为编辑内容，但我怀疑是Sql Server安装（也许是企业版或其他特定问题） ise缺少该安装），而不是基于上述内容的我的软件包。
I have been unable to track down fixes for the errors via Google, and they seem to be the same as when I target SQL Server 2014. I can post those as an edit if necessary, but my suspicion is the Sql Server installation (perhaps an issue specific to the Enterprise edition or something otherwise missing from that install) and not my package based on the above.
以下是第一个，也可能是最相关的错误：
Here are the first and likely most relevant errors:
推荐答案
我发现，如果从Visual Studio而不是内部生成的向导中进行部署，此错误就会消失。但是，我认为从Visual Studio部署时，您不能连接到远程SQL Server实例（我认为需要Windows登录）。
I found that this error goes away if you deploy from within Visual Studio instead of the wizard that is output by the build. However, I don't think you can connect to remote SQL Server instances when deploying from Visual Studio (I think that a Windows login is required).
因此，解决方案是在生产计算机上安装SSDT（Visual Studio 2015）并在本地部署。这显然不是很好，因为您每次要部署时都必须将SSDT项目移动到目标计算机（为此我使用Git）。
So the solution was to install SSDT (Visual Studio 2015) on the production machine and deploy locally. This is obviously not great because you then have to move the SSDT project to the target machine every time you want to deploy (i use Git for this).
确保微软最终会为此提供解决方案。尽管此刻我仍在等待他们发布Visual Studio 2017的SSDT。
I'm sure Microsoft will come up with a fix for this eventually... Although at the moment I'm still waiting for them to release SSDT for Visual Studio 2017.
== =编辑2017年10月
=== EDIT October 2017
SSDT现在在Visual Studio 2017中可用。但是，我发现我仍然必须从本地运行的Visual Studio进行部署（但是我不能记得为什么自几个月前从VS2017尝试过此方法以来）
SSDT is now available in Visual Studio 2017. However, I found that I still had to deploy from a locally running Visual Studio (but I can't remember why since having tried this a couple months ago from VS2017)
这篇关于将SSIS包部署到SQL Server 2016的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
