SSIS JSON Parser Transform

SSIS JSON Parser Transform can parse JSON string into multiple columns and rows (Helpful to extract data from raw JSON string stored as database column or coming from other source).

Features

Parse source JSON String/Documents into multiple columns/rows.
Ability to de-normalize nested JSON data into flat structure
Support for expression to extract nested data and convert single node into multiple rows (e.g. extract orders from customer document using expression $.Customer.Orders[*])
Option to parse output from command line Standard Output Stream (e.g. cmd:>curl -k http://httpbin.org/get)
Allow Regular Expression in Filter (e.g. $.store.books[?(@author =~ /^sam$/ )]
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Click here to see articles related to JSON Parser Transform

SSIS JSON Parser Transform – Parse JSON Document, Convert JSON to CSV or save to RDBMS (e.g. SQL Server, MySQL)

Extract Multiple Outputs from JSON using JSON Source and JSON Parser Transform

Extract multiple array output from JSON file / REST API response in (SSIS JSON Source, JSON Parser Transform)

Articles / Tutorials

Click here to see all articles for [SSIS JSON Parser Transform] category

How to Pivot CSV Data in SSIS

Introduction In our previous blog we saw How to write data into CSV file in SSIS (GZip / Split). Now in this blog, we will see How to Pivot CSV Data in SSIS using CSV Source. It also supports Pivot mode so you can convert single CSV string value into Rows. In this article we […]

How to read YouTube API data in SSIS (Videos, Channels, Playlists)

Introduction In last few articles we saw how to read data from various Google Services. In this article we will see how to read YouTube API data in SSIS. This blog mainly focus on SSIS approach but steps mentioned to call Google APIs can be useful for any developer regardless which programming language or toolset […]

SSIS Geocoding with Google Maps API

Introduction In this tutorial, we will cover the topics of how to perform geocoding on the addresses and reverse geocoding on the location coordinates using SSIS and Google Maps API. So what isÂ geocoding, exactly? GeocodingÂ is the process of translating an address (e.g. a street address) or a place to coordinates on the Earth’s surface. Simply […]

How to call Elasticsearch API using SSIS

Introduction ElasticsearchÂ is a powerful engine that allows you to store, aggregate and, most importantly, search data in a very analytical way. In this tutorial, you will learn how to bulk load data from SQL Server to ElasticsearchÂ withÂ SSISÂ (part of SQL Server) and ZappySys PowerPack. The scope of this article will be to show how to import […]