title: How to find version of installed SSIS
body: <p>It is local machine without an actual SQL server (just used for development)</p>
  
  <p>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.</p>
  
  <p>SQL server 2008R2 is installed with SDK, SSIS, and management studio</p>
  
  <p>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)</p>
  
  <p>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.</p>
  
  <p>However, visual studio 2013 can open .dtsx &amp; .sqlproj</p>
  
  <p>Everything looks fine (ignoring now this local instance contains SQL server 2008R2, 2012 and 2014 from 2008R2 discs, visual studio 2013 &amp; SSDTBI <a href="https://www.microsoft.com/en-us/download/details.aspx?id=42313" rel="nofollow noreferrer">https://www.microsoft.com/en-us/download/details.aspx?id=42313</a>)</p>
  
  <p>Lastly, when I open the .dtsx file (which should be 2008R2 version)</p>
  
  <p>The program will modify the format the XML to other format 
  from</p>
  
  <pre><code>&lt;DTS:Property DTS:Name="PackageFormatVersion"&gt;3&lt;/DTS:Property&gt;
  </code></pre>
  
  <p>to</p>
  
  <pre><code>&lt;DTS:Property DTS:Name="PackageFormatVersion"&gt;8&lt;/DTS:Property&gt;
  </code></pre>
  
  <p>It is checked means the SSIS package is in SQL server 2014 now.</p>
  
  <p>Thus the questions are
  How exactly to check the current SSIS version (not SSIS package or SQL server or SSDT)</p>
  
  <p>(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)</p>
  
  <p><a href="https://i.stack.imgur.com/V3132.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V3132.png" alt="enter image description here"></a></p>