question

JamesClark-2756 avatar image
0 Votes"
JamesClark-2756 asked JamesClark-2756 commented

How to set up the use of System.Text.Json within a SSIS Script Task?

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.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JamesClark-2756 avatar image
0 Votes"
JamesClark-2756 answered JamesClark-2756 commented

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!

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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.

0 Votes 0 ·
ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.