title: Convert string to presentable XML format in SSIS
body: <p>I have the following string that I want to convert to a presentable XML format. Presentable meaning, properly indented and carriage returned at appropriate spots. For some reason, I cant seem to get this to work. </p>
  
  <pre><code>&lt;HTML&gt;&lt;SSISLog&gt;&lt;PackageProperty&gt;&lt;PackageName&gt;Package&lt;/PackageName&gt;&lt;PackageID&gt;{67D67690-D437-42DB-80A2-A7FB68353E70}&lt;/PackageID&gt;&lt;/PackageProperty&gt;&lt;/SSISLog&gt;&lt;/HTML&gt;'
  </code></pre>
  
  <p>Can I use the xml task to do this job? Any inbuilt stored procedures for the same?</p>