how to install newtonsoft to global assembly cache for use in SSIS Script task

Raj D 581 Reputation points
2020-12-08T23:05:46.967+00:00

Hi, I am using newtonsoft dll to parse json data in SSIS script task. This works as expected on my local machine but when deployed to SQL Server and run from SQL Server job throws error "Exception has been thrown by target of an invocation". I am trying to install newtonsoft dll to global assembly cache. In order to accomplish this do I have to install Newtonsoft to the server for instance its saved to C directory. Then install it to global assembly cache using gacutil.

C:\Newtonsoft.Json.12.0.3\lib\net45\Newtonsoft.Json.dll

gacutil /i Newtonsoft.Json.dll

Thank you

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,446 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,891 Reputation points
    2020-12-09T06:13:03.503+00:00

    Hi @Raj D ,

    Please add assembly dll reference in SSIS Script Task.

    46447-addreference.png

    Hope the following link will be helpful:

    Reference Assembly in SSIS Script Task (.net Custom Assembly)

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?