title: SSIS Logging: Enable/Disable Logging Using Variable Instead of Re-Deployment
body: <p>I have an SSIS Package, call it <code>PackageA</code>.  Sometimes, I want to have it logging to  a text file, while other times, I do not.  My initial though was to have the package check a table, then use a variable/expression to enable/disable logging.  I am assuming this is not possible?</p>
  
  <p>My work around is to create a "master" package, <code>PackageB</code>, with a SQL task to get whether or not to enable logging.  <code>PackageB</code> would call <code>PackageA1</code> or <code>PackageA2</code> depending on the value--<code>PackageA1</code> would be <code>PackageA</code> deployed with logging enabled and <code>PackageA2</code> would be <code>PackageA</code> deployed with logging disabled.</p>
  
  <p>That makes deployment a hassle and easy to mess up, however. Is there any way to accomplish, at the very least, something similar to what I am looking for?</p>
  
  <p>Thanks!</p>