title: Run SSIS package from C# , and limit the memory usage
body: <p>I am runnig an SSIS package from C# code like so: </p>
  
  <pre class="lang-cs prettyprint-override"><code>ErrorHandler errorHandler = new ErrorHandler();
  Application app = new Application();
  DTSExecResult res;
  Package pkg = app.LoadPackage(packagePath, null);
  res = pkg.Execute(null, null, errorHandler, null, null);
  </code></pre>
  
  <p>I have two questions:</p>
  
  <ol>
  <li><p>What "engine" runs this package ? Does SQL Server runs it, or a smaller SSIS engine is the only thing needed.</p></li>
  <li><p>When this c# code (it's a console application) runs for long periods it eats up more and more memory gradually. How can I limit the memory usage of the package being run ?</p></li>
  </ol>
  
  <p>*One idea that came to mind that this behavior is like SQL Server behavior i.e. it takes up memory and never releases it, of course under the memory limit defined. So maybe the "engine" that runs the package is set up with a certain memory limit which gradually gets filled.</p>