Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed

Question

Hi

I have added a NewtonSoft. JSON dll in Script task, it is working locally, when deployed and trying to run through SQL Agent Job, getting error as "Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed".

Already added NewtonSoft JSON dll locally in

C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn

Answer 1

Hi @Ajay Jha，

Please check your sql server version and make sure it is SQL2016, if it is SQL 2019, please first set the target server version to SQL2019 in VS and add the dll to 150 folder.

Also make sure the account used to run the job has full permission to the folder.

Or check if it is a 32bit vs 64bit issue.

1. Open SQL Server Agent → Job Properties.
2. Go to the Step that runs SSIS.
3. Click Edit → Go to Execution Options.
4. Check "Use 32-bit runtime".

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.