title: Transform log4net Appender Connection String Using Octopus Deploy
body: <p>I have a number of named appenders configured in my <code>web.config</code> files and I'm wondering if it is possible to address these as normal Variable transforms as part of a standard deployment?</p>
  
  <p>What I want to be able to change is the value of the <code>connectionString</code></p>
  
  <p>The XML looks like this:</p>
  
  <pre><code>&lt;appender name="AdoNetAppender_DNOA" 
         type="log4net.Appender.AdoNetAppender"&gt;
        &lt;immediateFlush value="true" /&gt;
        &lt;connectionType value="System.Data.SqlClient.SqlConnection, 
             System.Data, Version=1.0.3300.0, 
             Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;
        &lt;connectionString 
              value="data source=MyServer;initial catalog=DNOALog_Dev;
              integrated security=false;persist security info=True;
           User ID=UserId;Password=pwd" /&gt;
  </code></pre>