title: How do I extract a value from SSIS package file using PowerShell?
body: <p>Sql Server Integration Services packages are stored as xml files with a dtsx extension. I need to be able to extract their build numbers with Powershell. The relevant part at the top of the file looks like-</p>
  
  <p><code>&lt;?xml version="1.0"?&gt;</code><br>
  <code>&lt;DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"&gt;</code><br>
  <code>&lt;DTS:ExecutableType="MSDTS.Package.1"&gt;</code><br>
  <code>&lt;DTS:Property DTS:Name="PackageFormatVersion"&gt;2&lt;/DTS:Property&gt;</code><br>
  <code>&lt;DTS:Property DTS:Name="VersionMajor"&gt;1&lt;/DTS:Property&gt;</code><br>
  <code>&lt;DTS:Property DTS:Name="VersionMinor"&gt;0&lt;/DTS:Property&gt;</code><br>
  <code>&lt;DTS:Property DTS:Name="VersionBuild"&gt;265&lt;/DTS:Property&gt;</code>  </p>
  
  <p>I need to extract the VersionBuild number, but the DTS namespace is confusing me. After I do the get-content, how can I get at the value?</p>