SSIS Export JSON File Task

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

Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements

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

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 Generate JSON File Task - Generate JSON files for selected tables/views

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 - Select Target Path and other options

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 - Layout editor for nested JSON elements

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 - Split JSON Data into Multiple files

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 - Export to Azure Bob Storage, 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 - JSON Date Formatting, Encoding Options

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

SSIS Export JSON File Task – Execution Log

SSIS Export JSON File Task - Execution Log

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)

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

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

 

See Also

Articles/Posts

SQl Server Logo

SQL Server JSON Export from Table or Query Data

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 Logo

SQL Server Excel Export from Table or Query data

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

Oracle Logo

Oracle CSV Export from Table or Query Data

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 Logo

SQL Server CSV Export from Table or Query Data

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

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

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

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

References

Click here to learn more about System Requirements

Download View All Tasks Like This