如何查找已安装 SSIS 的版本 [英] How to find version of installed SSIS

问题描述

它是本地机器，没有实际的SQL服务器(仅用于开发)

通过运行 DTEXEC，它检索到Microsoft (R) SQL Server 执行包实用程序32 位版本 10.50.1600.1版权所有 (C) Microsoft Corporation 2010.保留所有权利.

SQL server 2008R2 已安装 SDK、SSIS 和 management studio

Visual Studio 2013 已安装，但由于某些未知原因 SSDT 未向 SSIS 提供完整功能(包括 .dtsx 无法打开和 .sqlproj 无法打开)

别无选择，只能为 Visual Studio 2013 安装了一个名为 SSDTBI 的包.可笑的是只能安装 32 位应用程序(我的操作系统是 64 位)并且它强制安装了 SQL Server 2014.

但是，visual studio 2013 可以打开 .dtsx &.sqlproj

一切看起来都很好(现在忽略这个本地实例包含来自 2008R2 光盘的 SQL server 2008R2、2012 和 2014、visual studio 2013 和 SSDTBI

解决方案

因此问题是如何准确检查当前的 SSIS 版本(不是 SSIS 包或 SQL 服务器或 SSDT)

一台服务器可以安装多个版本的 SSIS.这可能是由就地升级引起的.

可以使用SQL Server 配置管理器发现已安装的主要版本:

构建、版本和工具要求:

SQL Build# PackageFormatVersion Visual Studio 版本(SSDT)2005 9 2 20052008 10 3 20082008 R2 10.5 3 20082012 11 6 2010 或 BI 20122014 12 8 2012 CTP2 或 20132016 13 8 20152017 14 8 2015/2017

<块引用>

是否可以在没有遇到问题的情况下打开 SSIS 项目?

默认情况下，BIDS 会在升级过程中创建包的备份

It is local machine without an actual SQL server (just used for development)

By running DTEXEC it retreived Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.

SQL server 2008R2 is installed with SDK, SSIS, and management studio

Visual studio 2013 is installed but due to some unknown reason SSDT did not provide full features to SSIS (included .dtsx cannot open and .sqlproj cannot open)

No choice but installed a package called SSDTBI for visual studio 2013. Ridiculously only 32 bit application can be installed(my os is 64bit) and it forces SQL server 2014 installed.

However, visual studio 2013 can open .dtsx & .sqlproj

Everything looks fine (ignoring now this local instance contains SQL server 2008R2, 2012 and 2014 from 2008R2 discs, visual studio 2013 & SSDTBI https://www.microsoft.com/en-us/download/details.aspx?id=42313)

Lastly, when I open the .dtsx file (which should be 2008R2 version)

The program will modify the format the XML to other format from

<DTS:Property DTS:Name="PackageFormatVersion">3</DTS:Property>

to

<DTS:Property DTS:Name="PackageFormatVersion">8</DTS:Property>

It is checked means the SSIS package is in SQL server 2014 now.

Thus the questions are How exactly to check the current SSIS version (not SSIS package or SQL server or SSDT)

(Skipped) Is it possible to open SSIS items without the encountered issues? - it is checked that visual studio 2013 is proposed to manage SSIS package with version 8. Thus it is normal behaviors instead of issue (editing SSIS package version 3 should use visual studio 2008 with BI instead)

解决方案

Thus the questions are How exactly to check the current SSIS version (not SSIS package or SQL server or SSDT)

One server can have multiple versions of SSIS installed. This can be caused by in-place upgrades.

Installed Major versions can be discovered by using SQL Server Configuration Manager:

Builds, versions and tools requirements:

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
2017      14        8                   2015/2017

Is it possible to open SSIS items without the encountered issues?

By default, BIDS creates a backup of package during upgrade

这篇关于如何查找已安装 SSIS 的版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！