title: Upgrade SSIS Package Using SMO to SQL Server 2019
body: <p>I have a SSIS package that was originally developed to target SQL Server 2015 that does a variety of things in C# Scripts using SQL Server Management Objects (SMO) that now needs to be upgraded to target SQL Server 2019. Eventually, this package is deployed to the server to run in a SQL Agent Job.</p>
  <p>Starting in SQL Server 2017, SMO was moved to a NuGet package and is no longer included in SQL Server Feature Packs as it was for previous versions.</p>
  <p>The issue I have is that Integration Services Projects do not really support NuGet. As discussed in the below link:</p>
  <p><a href="https://stackoverflow.com/questions/37681631/ssis-script-task-cant-find-reference-to-assembly">SSIS Script Task cant find reference to assembly</a></p>
  <p>As mentioned in the above ticket, I believe I could manually install the .dll's to the server if necessary but I am curious if there are other solutions to this issue.</p>
  <p>Questions:</p>
  <ul>
  <li>Is there a way to get Script Tasks in SSIS packages to utilize the SMO NuGet?</li>
  <li>If &quot;no&quot; to the above, is there another common method of executing C# script via SQL server other than installing the .dll's to the server?</li>
  </ul>