Link to home
Start Free TrialLog in
Avatar of vsuripeddi

asked on

Script Component in SSIS giving error after writing code for JSON file parsing

I am new to SSIS
I am using a Script component in SSIS for parsing a JSON file.
I am getting errors after I add the C# code in the Script component for parsing of the JSON file.

I am attaching a file which describes the issue that I am facing.
Is this a bug in the Software of Visual Studio 2015 professional? Do I need to re-install Visual Studio 2015 professional?
Avatar of Kelvin McDaniel
Kelvin McDaniel
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vsuripeddi


@Kelvin McDaniel,

Thanks for the update....
I am using SQL Server 2017 developer edition

I am not sure if 2017 developer version has any service packs...

The link you had provided suggests that I change the value to 1 in the Registry Editor

I tried to go into the path
"Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy" and change the value to 1
However, it did not allow me to change to 1
Also, I could not locate service packs for SQL Server 2017 Developer edition
@Kelvin McDaniel

I used SSDT tools for Visual Studio 2015 professional edition
That's what I figured. That particular setting is not typical for non-corporate/consultant environments and -- more than likely -- it's controlled by policy.

At this point, I think your lowest common denominator option is to create a dll that handles ingesting the file into a collection, which SSIS can then use in its flows. Hopefully, that one layer of abstraction will keep you from getting hit with that exception. If not, then you'll probably have to completely externalize that step.

To be clear:
1. Create a DLL  that SSIS can reference.
2. Use something like FileHelpers to turn the text into a useable collection.
3. Update your to call a method in this DLL, which will return the collection made in #2 above.