Reading multiple arrays from JSON/XML in SSIS

Sometimes you want to read multiple arrays from JSON/XML that are on the same level. E.g.:

{
    "ArrayA": [0, 1, 2, 3],
    "ArrayB": [4, 5, 6, 7]
}

 

In this case, you will have to use either multiple JSON/XML Source components and load JSON/XML several times or load it once with JSON/XML Source and use a standard SSIS component - Multicast:

 

Check this article for detailed instructions

 

 

 

Approach #1 - Read Source data once (Output Raw) and parse multiple times using MultiCast + JSON Parser Transform

 

 

 

Multicast approach (the recommended way):

 

Approach #2 - Read Source data multiple times using multiple sources

 

Check a related article for more info.

 

 

Video Tutorial - Read from multiple arrays from JSON document

 

 

 

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/