SQL Server集成服务版本 [英] SQL Server Integration Services Version

问题描述

我有一个已安装SQL Server 2012的生产系统，因此该系统具有Integration Services11.然后，我们使用SQL Server 2014对该系统进行了升级，因此该系统具有两个Integration Services 11& 12.然后我们升级到SQL Server 2016，因此系统现在具有三个Integration Services 11、12和12. 13.

I have a production system which had installed SQL Server 2012, so this system has the Integration Services 11. Then we upgraded the system with SQL Server 2014, so the system had two Integration Services 11 & 12. Then we upgraded to SQL Server 2016, so the system has now three Integration Services 11, 12 & 13.

我在Internet上进行了一些研究，但我意识到，即使我们升级SQL Server，集成服务也是并行安装的.还可以从SQL Server管理控制台中确认这一点.

I done some research on the Internet and i realized that even we upgrade the SQL Server the integration services are installed side-by-side. This is also confirmed from SQL Server Management Console.

当我在CMD上运行DTEXEC时，默认版本为11，这意味着SSISB目录中的DTSX程序包正在使用Integration Services 11运行，而不是最新版本?如果这是正确的，我该如何将其更改为最新的?

When i run DTEXEC on CMD get default version 11, this means that my DTSX packages inside the SSISB Catalog are running using the Integration Services 11 and not the latest one? If this is correct how can i change this to the newest one?

推荐答案

我最近是这种讨论的一部分.务必先了解SSIS向后兼容性.

I was recently part of such discussion. It is important to understand SSIS Backward compatibility before.

此外，请通过其SQL Server数据工具版本引用SSIS，因为大多数人以这种方式理解它.您可以将您的想法与以下提到的细节联系起来:

Also, refer SSIS through its SQL Server Data Tools version, as most commonly people understand it in that way. You can link your thoughts with below mentioned details:

SQL      Build#  PackageFormatVersion   Visual Studio Version(SSDT)
2005       9        2                   2005
2008      10        3                   2008
2008 R2   10.5      3                   2008
2012      11        6                   2010 or BI 2012
2014      12        8                   2012 CTP2 or 2013
2016      13        8                   2015

来源: sqlstudies

来自

From this microsoft document you'll understand which SSIS version is compatible with which SQL Server.

简而言之:

Target version of SQL Server    Development environment for SSIS packages
2016                            SSDT 2015
2014                            SSDT 2015 or SSDT-BI 2013
2012                            SSDT 2015 or SSDT-BI 2012  

简单来说，SSDT 2015可以从2012年开始部署在任何服务器上，而2012、2013年是限制性的.

In simple words, SSDT 2015 is capable of deployment on any server from 2012 onwards, whereas 2012, 2013 are restrictive.

请注意，如果在SSDT 2015中打开sql server 2012 dtsx，则无法再从SSDT-BI 2012中打开它.

Beware that, if you open sql server 2012 dtsx in SSDT 2015, then you cannot go back to open it from SSDT-BI 2012.

如果这是正确的，我该如何将其更改为最新版本?

If this is correct how can i change this to the newest one?

因此，如果要升级所有软件包，请通过SSDT-2015打开它们，选择部署版本(右键单击项目->属性->目标服务器版本).

Hence, if you want to upgrade all your packages, open them through SSDT-2015, select deployment version(right click project -> properties -> Target Server Version).

您可以阅读有关这些更改的更多信息

you can read more about these changes here(MSSQLTips)

这篇关于SQL Server集成服务版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！