将 SSIS 包部署到 SQL Server 2016 [英] Deploying SSIS Package to SQL Server 2016

问题描述

我在 VS 中有一个 SSIS 项目:

I have an SSIS project in VS:

Microsoft Visual Studio 专业版 2015版本 14.0.25431.01 更新 3微软 .NET 框架版本 4.6.01590SQL Server 数据工具 14.0.61116.0Microsoft 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 服务器实例上成功部署和验证，但不能在第三个实例上部署和验证.

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) 微软公司Windows Server 2012 R2 Datacenter 6.3(内部版本 9600:)(管理程序)上的开发人员版(64 位)

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) Sep 5 2017 16:12:34 版权所有 (c) Microsoft Corporation Enterprise Edition:Windows 上的基于内核的许可(64 位)Server 2012 R2 数据中心 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 安装(也许是企业版特有的问题或该安装中缺少的其他问题)而不是基于上述内容的我的软件包.

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屋！