How to flatten/denormalize JSON/XML in SSIS?

Usually, you want to flatten JSON/XML you want to parse. And it is very simple to do it because it is done automatically by JSON/XML Source, so you don't need to do anything:

If you want to flatten an array just use a Filter by pressing Select Filter button:

More articles related to reading and flattening JSON:

• Reading JSON Arrays from file / REST API
• Parse multi-dimensional JSON array in SSIS

Check an attached SSIS Package (SQL Server 2012) for some samples. 

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/