SSIS JSON Parser Task (FREE)

SSIS JSON Parser Task can be used to extract single or multiple values out of JSON document in control flow. You can extract value from content stored in direct value, SSIS Variable or File. Simply specify JSONPath expression or type property name you wish to extract from JSON Document.

Features

Read JSON Document and extract single or multiple properties by name or JSONPath expression
Read JSON Document from direct string, JSON file or SSIS Variable
Automatically Parse possible fields from JSON document
Support for Test JSON Parse settings
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory

Drag and drop ZS JSON Parser Task to the design panel

Drag and drop ZS JSON Parser Task to the design panel. With the installer, you will also have another free tool the ZS Logging Task and join the components with the green arrow.

SSIS JSON Parser Task configure it

SSIS JSON Parser Task – Test JSON Path Settings

Finally, run the packages and check the output

SSIS JSON Parser Task – Parse JSON Values

Articles / Tutorials

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

Parse JSON using SQL Server 2014 or lower

Parse JSON using SQL Server 2014 or lower Hello, this time we will show how to parse JSON in SQL Server 2014 or other versions. we will use a simple tool easy to use and we do not need programming knowledge. Solution In this article we will learn how to parse JSON inÃÂ SQL Server using […]

How to Import / Export data from Zuora API using SSIS

Introduction In this post, we will learn how to call Zuora API using SSIS.ÃÂ We will go through steps to read data from Zuora and load into SQL Server using ÃÂ SSIS REST API TaskÃÂ andÃÂ ÃÂ SSIS JSON Source ConnectorÃÂ . At the end of this article, you will find a complete sample (dtsx file). Tasks/Components in […]

Articles/Posts

Oracle CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install Oracle Drivers3.1 Sample Oracle ODBC Connection String3.2 Sample Oracle OLEDB Connection String4 Oracle CSV Export – Single table5 Oracle CSV Export – Multiple tables6 Oracle CSV Export – Multiple tables (using pattern)7 Oracle CSV Export – SQL Query8 Oracle CSV Export – Split […]

SQL Server Excel Export from Table or Query data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution3.1 Export Tables to CSV Using – ZappyShell Command Line Tools3.2 Export Tables to CSV Using – SSIS Export CSV File Task4 Download and Install ZappyShell Command Line Tools5 SQL Server Excel Export – Single table6 SQL Server Excel Export – Multiple tables7 SQL Server Excel Export – Multiple tables (using […]

SQL Server JSON Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution4 Export SQL Server data to JSON using SSIS PowerPack5 Export SQL Server data to JSON using ZappyShell Command line6 SQL Server JSON Export – Single table7 SQL Server JSON Export – Multiple tables8 SQL Server JSON Export – Multiple tables (using pattern)9 SQL Server JSON Export – SQL Query10 Using […]

SQL Server CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install SQL Server Drivers3.1 Sample ADO.net Connection String (No driver needed)3.2 Sample ODBC Connection String (SQL Native Client Driver)3.3 Sample OLEDB Connection String (SQL Native Client Driver)4 SQL Server CSV Export – Single table5 SQL Server CSV Export – Multiple tables6 SQL Server CSV […]

MySQL CSV Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 Download and Install MySQL ODBC Driver3 Download and Install ZappyShell Command Line Tools4 MySQL CSV Export – Single table5 MySQL CSV Export – Multiple tables6 MySQL CSV Export – Multiple tables (using pattern)7 MySQL CSV Export – SQL Query8 MySQL CSV Export – Split Files8.1 MySQL CSV Export – Split By Row Count8.2 […]

MySQL Excel Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL Excel Export – Single table7 MySQL Excel Export – Multiple tables8 MySQL Excel Export – Multiple tables (using pattern)9 MySQL Excel Export – SQL Query10 MySQL Excel Export – Split Files and Tabs10.1 MySQL Excel Export […]

MySQL JSON Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL JSON Export – Single table7 MySQL JSON Export – Multiple tables8 MySQL JSON Export – Multiple tables (using pattern)9 MySQL JSON Export – SQL Query10 Using Map File for nested MySQL JSON Export11 MySQL JSON Export […]