Newtonsoft error in SSIS. How to configure?

  • Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=xxxxxx' or one of its dependencies. The system cannot find the specified file.

    I'm using Newtonsoft on SSIS.

    But when running the package this error is displayed. Please, how can I perform this configuration?

     

     

  • Have you added the Newtonsoft DLL to the GAC?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Hi Phil Parkin.

    I didn't add the DLL to the GAC because I have little knowledge of C#. I'm studying to develop projects.

    If there is any link or video that can help with understanding, I'm very grateful.

  • In order for SSIS to find the Newtonsoft assembly when the package runs, you need the following two things to be in place:

    1. The assembly to be in the GAC (installed using GACUtil)
    2. A reference to the Newtonsoft DLL in your Script Task. Add this after you have added the DLL to the GAC and ensure that the reference points to the GAC version of the assembly.

    (Using Nuget in SSIS probably won't work, once a package has been deployed.)

    Have a look at this link for some additional information: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0633f589-f9ab-4806-93cd-9e0c2cebcbd7/use-newtonsoftjson-in-ssis-via-script-component?forum=sqlintegrationservices

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply