I would like to be able to use the new Microsoft assembly System.Text.Json from within a Microsoft SQL Server Integration Service Script Task. I need help setting it up on my development computer in addition to setting it up on the SSIS server.
I would like to be able to use the new Microsoft assembly System.Text.Json from within a Microsoft SQL Server Integration Service Script Task. I need help setting it up on my development computer in addition to setting it up on the SSIS server.
I successfully added two dependent assemblies to the server GAC for System.Text.Json version 4.0.1.0. They include System.Buffers.dll version 4.0.2.0 and System.Memory.dll version 4.0.1.1. I haven't attempted to get the latest version of System.Text.Json installed because it looks to be more complicated; if someone can figure this out and post the detailed list of assemblies with versions, please post here!
HI James,
I know this is almost a year old, but would you mind describing where you obtained the dependent assemblies from?
I am having the exact same issue, everything works fine on my dev machine, but when i deploy the package to SSIS it fails.
The message is it cannot find the buffers.dll v4.0.2.0 (The dependat dll you mentioned)
I have copied the dlls from my dev environment & gacutil'd them into the GAC on the Server.
But i can only find v4.0.3.0 not the 4.0.2.0 required.
Any help appreciated
John
This was a difficult problem to overcome for sure. I don't remember where I found it, but if you send me an email, I will respond with the DLL.
Hi @JamesClark-2756,
Not sure if you want is like below.
You may carefully refer to see if it is helpful.
http://binaryworld.net/blogs/reference-assembly-in-ssis-script-task-net-custom-assembly/
Regards,
Zoe
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 October
6 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh