SSIS Parse Json

Asked Jan 07 '19 at 13:59

Active Jan 07 '19 at 13:59

Viewed 492 times

I am trying to parse a json inside an SSIS package with a script component.

I have - MVS 2017 (SSDT) - MS Visual C# 2017, - .NET Framework 4.5

The NuGet Manager suggests the Newtosoft.Json V: 9.0.1 as the latest.

After instelling it I use the following code to test the task :

        dynamic result = JsonConvert.DeserializeObject("{ 'betType': 'Jon Smith'}");

And I get the error:

  System.IO.FileNotFoundException: Could not load file or assembly 'Newtonsoft.Json, Version=9.0.0.0 ...

Also., in the solution explorer of the script component under the references the Version of the Newtonsoft.Json is 9.0.0.0.

I tried to reinstall the package but it didn't work. Also no later version is available through the nuget manager.

asked Jan 07 '19 at 13:59

gematzab

Basically create classes to match your JSON as this example https://stackoverflow.com/questions/7895105/deserialize-json-with-c-sharp – KeithL Jan 07 '19 at 14:04
@KeithL thank you for your answer. so you suggest to use the JavaScriptSerializer() ? – gematzab Jan 07 '19 at 14:36
What happens if you change Copy Local from False to True? – Brian Rogers Jan 07 '19 at 17:13
I always use it. I typically work in environments where 3rd party tools are not allowed (netwonsoft in your case) – KeithL Jan 07 '19 at 18:36
@KeithL Thank You for the helo .it worked – gematzab Jan 09 '19 at 09:25

0 Answers0