SSIS JSON Parser Task

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

Download Help File
View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements

Drag and drop ZS JSON Parser Task to the design panel

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

SSIS JSON Parser Task – Test JSON Path Settings

Finally, run the packages and check the output

SSIS JSON Parser Task - Parse JSON Values

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

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

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 […]

See Also

Articles/Posts

Oracle Logo

Oracle CSV Export from Table or Query Data

Introduction In this article we will learn how to use ZappyShell Command Line Tools for Oracle CSV Export from Table or Query result ZappyShell for DB can export your Oracle data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to export data […]

0 comments
SQl Server Logo

SQL Server Excel Export from Table or Query data

Introduction In this article we will learn how to use ZappyShell Command Line Tools for SQL Server Excel Export from Table or Query result The problem SQL Server comes with few tools to export data to excel but if you ever try it you will realize its not as easy as it sounds. Solution There […]

0 comments
SQl Server Logo

SQL Server JSON Export from Table or Query Data

Introduction JSON File format is becoming very popular due to its simplicity and smaller size. Most of NoSQL Databases are now using JSON for their document mechanism. In this article we will learn how to use various techniques to generate JSON data files from SQL Server Table or any other relational source such as MySQL […]

SQl Server Logo

SQL Server CSV Export from Table or Query Data

Introduction In this article we will learn how to use ZappyShell Command Line Tools for SQL Server CSV Export from Table or Query result ZappyShell for DB can export your SQL Server data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to […]

0 comments

MySQL CSV Export from Table or Query result

Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL CSV Export from Table or Query result ZappyShell for DB can export your MySQL data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to export data […]

0 comments

MySQL Excel Export from Table or Query result

Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL Excel Export from Table or Query result The problem There is no native way of Exporting MySQL Data to Excel. You can use some coding techniques or libraries but when things become complex you will run out of options […]

1 comment

MySQL JSON Export from Table or Query result

Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL JSON Export from Table or Query result JSON File format is becoming very popular due to its simplicity and smaller size. Most of NoSQL Databases are now using JSON for their document mechanism. The problem There is no native […]

0 comments

References

Click here to learn more about System Requirements

Download View All Tasks Like This