SSIS Export JSON File Task

SSIS Export JSON File Task can be used to generate simple or complex JSON files out of relational data source such as SQL Server, Oracle, MySQL. It also support exporting directly to cloud (e.g. Azure Blob Storage, Amazon AWS S3, Secure FTP). In few clicks you can create desired JSON Shape from single or multiple tables (Parent/Child Nested Documents)

Features

Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
Export SQL query output to JSON files (export to local disk or cloud storage)
Ability to save JSON output into SSIS variable or file
Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
Automatically Split exported JSON data into multiple files by Size or Number of records
Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
Support for cloud storage (e.g. Azure Blob, Amazon AWS S3, FTP/SFTP). Export multiple SQL tables dynamically to cloud storage (Pro Edition Feature).
Support for Compression and Append
Create Multi content JSON documents
Allow multiple characters in SourceSplitChar Property to allow multiple SQL Statements (i.e. || rather than | )
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: JSON related articles

In visual studio just Drag and Drop ZS Export JSON Task in design panel

Drag and Drop ZS Export JSON Task in design panel

SSIS Generate JSON File Task – Generate JSON files for selected tables/views

SSIS Export JSON File Task – Select Target Path and other options

SSIS Export JSON File Task – Layout editor for nested JSON elements

SSIS Export JSON File Task – Split JSON Data into Multiple files

SSIS Export JSON File Task – Export to Azure Bob Storage, , Amazon S3, SFTP (Dynamically Export Multiple tables, Split, Compress GZip)

SSIS Export JSON File Task - Export to Azure Bob Storage, SFTP (Dynamically Export Multiple tables, Split, Compress GZip)

SSIS Export JSON File Task – Export to Azure Bob Storage, , Amazon S3, SFTP (Dynamically Export Multiple tables, Split, Compress GZip)

SSIS Export JSON File Task – Browse Cloud Export Location for Azure Bob Storage, Amazon S3, SFTP

SSIS Export JSON File Task – JSON Date Formatting, Encoding Options

SSIS Export JSON File Task – Execution Log

How to export JSON in 2D Array format

If you have to export JSON as 2D array format then you can change following option.

SSIS Export JSON File Task - Export as 2D Array

Here are examples of output for each option.
Select say you have source data with 2 columns id and name.

Default

[{id:1,name:"AA"}, {id:2,name:"BB"}]

Multicontent

{id:1,name:"AA"}{id:2,name:"BB"}

ArrayDocs

[{id:1,name:"AA"}, {id:2,name:"BB"}]

Array2D

[[1,"AA"],[2,"BB"]]

Array2DWithHeader

[["id","name"],[1,"AA"],[2,"BB"]]

ArrayLines

[1,"AA"][2,"BB"]

ArrayLinesWithHeader

["id","name"][1,"AA"][2,"BB"]

Articles / Tutorials

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

SSIS Data Load â SQL Server to FTP/SFTP (Split Files, GZip)

Introduction In this blog post you will see how easy it is to load large amount of data from SQL Server to FTP/SFTP. SSIS Data Load â SQL Server to FTP/SFTP (Split Files, GZip). For demo purpose we will use SQL Server as relational source but you can use same steps for any database engine […]

5 Ways to Export JSON from SQL Server using SSIS

Introduction SQL Server 2012Â and all previous versions lacking native JSON support, same theory is true for their ETL Platform SSIS. If you are one of them who wants to export JSON from SQL Server or any other RDBMS like MySQL, Oracle then you can easilyÂ output complexÂ JSON using any of the following components. Five ways of […]

Articles/Posts

SQL Server JSON Export from Table or Query Data

Posted: June 10, 2015

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 Excel Export from Table or Query data

Posted: June 10, 2015

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

Oracle CSV Export from Table or Query Data

Posted: June 10, 2015

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 CSV Export from Table or Query Data

Posted: June 10, 2015

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 Excel Export from Table or Query result

Posted: June 5, 2015

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 CSV Export from Table or Query result

Posted: June 5, 2015

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 JSON Export from Table or Query result

Posted: June 5, 2015

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