SSIS System.Text.JSON

[Igelchen]

Hello everyone,

to query data via a REST API (the third-party system can only be queried via REST API) I use a Script Task in C#.

The query works very well and the performance is excellent when using the JSON Library System.Text.JSON.

Because JSON library is not integrated on the SQL server by default, it would have to be installed as a NuGet package.

The first link below indicates that the following requirement must be met: "make sure to include previews and install version 4.6.0-preview6.19303.8 or higher".

Does updating the .Net Framework or installing the latest .Net Runtime on the Windows Server - running SQL Server - affect what can be used in SSIS at all?

And will ist be possible, to use the JSON library in SSIS after installing the NuGet package on the underlying Windows server?

See also:

https://devblogs.microsoft.com/dotnet/try-the-new-system-text-json-apis/

https://docs.microsoft.com/de-de/do...n/system-text-json-overview?pivots=dotnet-6-0

I would be very grateful for explanation.

Best wishes