title: SQL Server SSIS Custom assembly with licence key
body: <p>I have an SSIS package that runs fine from Visual Studio but doesn’t work on the server.</p>
  
  <p>Executing under my security context produces the same results as a proxy account.</p>
  
  <p>It's running a custom assembly</p>
  
  <ul>
  <li>The server is running SQL Server 2016</li>
  <li>The server has the shared components installed on a different drive (d:)</li>
  <li>There is a script task that needs a licence key</li>
  <li>Runs fine locally using Visual Studio 2013 (I edited 64 &amp; 32 bit versions of DtsDebugHost.exe.config)</li>
  <li><p>On the server I installed three dll's to the GAC &amp; placed a copy in Program Files and (x86) \Microsoft SQL Server\130\SDK\Assemblies\</p>
  
  <ol>
  <li>a.dll          - MSIL</li>
  <li>b.dll          - MSIL</li>
  <li>kernelx86.dll  - X86</li>
  </ol></li>
  </ul>
  
  <p>One of them wouldn't install to the GAC until I edited the GACUTILs config and put the below line in.
  
  Then I edited the config files for running SSIS packages;</p>
  
  <pre><code>1. DTExec.exe.config - Command line execution  
  2. DtsDebugHost.exe.config - Visual Studio debugging  
  3. DtsHost.exe.config - SQL Server agent
  </code></pre>
  
  <p>Either one of the DLLs isn't being used or the licence key still isn't being picked up.</p>
  
  <p>Any suggestions are appreciated,</p>
  
  <p>Dan</p>