title: How to force SSIS deployement manifest files to use a particular version of DTSInstall.exe
body: <p>I have an SSIS package developed in Business Intelligence Development Studio (BIDS) 2005  and the target deployment server is also SQL Server 2005.</p>
  
  <p>However, on my development machine i also have full installations of both SQL Server 2008 and 2012 installed.</p>
  
  <p>I have created an Integration Services Deployment manifest to install the package. The problem is, during the installation the package installation wizard is upgrading my package from PackageFormatVersion 2 to  PackageFormatVersion 6 and version 6 is not supported on the production server.</p>
  
  <p>My guess is that, the Integration Services Deployment manifest is using the DTSInstall.exe file for SQL Server 2012 instead of the DTSInstall.exe for SQL Server 2005.</p>
  
  <p>If i open the .dtsx file in a text editor before running the package installation utility, i have below values</p>
  
  <pre><code>&lt;DTS:Property DTS:Name="PackageFormatVersion"&gt;2&lt;/DTS:Property&gt;
  </code></pre>
  
  <p>and then after running the package installation utility, 2 is changed to 6 as below</p>
  
  <pre><code>&lt;DTS:Property DTS:Name="PackageFormatVersion"&gt;6&lt;/DTS:Property&gt;
  </code></pre>
  
  <p>That change makes it fail to run on the target production server. Is there away i can ensure that the PackageFormatVersion remains 2 after running the package installation utility?</p>
  
  <p>See the difference in the screenshoots below. In the first screenshot, the SSISDeploymentManifest file opens with specifically SQL Server 2005 integration services package installation utility while in screenshot 2 it opens with just generic SQL Server integration services package installation utility.</p>
  
  <p>How can i specifically select sql server 2005 in screenshot 2 the way it is in screenshot 1.</p>
  
  <p><img src="https://i.stack.imgur.com/QCvLV.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/LYPUs.png" alt="enter image description here"></p>