JSON Generator TransformSSIS JSON Generator Transform can be used to generate single or multiple JSON documents from any type of datasources (e.g. SQL Server, MySQL, Flat File, Excel) inside dataflow task. Features
|
||||
|
View All Tasks |
SSIS JSON Generator Transform – Add/Edit Dataset
JSON Generator Transform – Add/Edit Dataset
SSIS JSON Generator Transform – Add/Edit Attribute
JSON Generator Transform – Add/Edit Attribute
SSIS JSON Generator Transform – Add/Edit Document Array
JSON Generator Transform – Add/Edit Document Array
SSIS JSON Generator Transform – Add/Edit Value Array
JSON Generator Transform – Add/Edit Value Array
SSIS JSON Generator Transform – Layout Editor (Define nested elements and Parent-Child relation)
JSON Generator Transform – Layout Editor (Define nested elements and Parent-Child relation)
SSIS JSON Generator Transform – Test JSON Path Settings
Loading Raw JSON documents into MongoDB
Batch records in multiple JSON documents
Batch records in multiple JSON documents
How to generate JSON in 2D Array format
If you have to generate JSON as 2D array format, then you can change following option.
You can select either Add Document Array or Add Value Array option based on your requirement, just like the below screenshot.
JSON Generator OR Destination – Add Document OR Value Array
In Add/Edit Element modal, you can select Output as Compact 2D Array checkbox, as highlighted in the below screenshot.
JSON Generator OR Destination – Add Edit Element for 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 Generator Transform] category
 |
How to Pivot CSV Data in SSISIntroduction 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 batch REST API requests in SSIS (Bulk Operation)Introduction In our previous article we saw how to POST data to REST API using few different ways. Now let’s go one step further and discuss another common scenario to batch REST API requests in SSIS. For efficient data transfer many API provides you to submit multiple records in a single request. In this article […] |
 |
How to read / write data in Google BigQuery using SSISIntroduction Google BigQuery is a fully managed Big Data platform to run queries against large scale data. In this article you will learn how to integrate Google BigQuery data into Microsoft SQL Server using SSIS. We will leverage highly flexible JSON based REST API Connector and OAuth Connection to import / export data from Google […] |
 |
Loading data from SQL Server to Elasticsearch with SSISIntroduction 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 […] |
 |
How to create MongoDB documents (JSON, BSON) for loading in SSISIntroduction In our previous article we discussed how to load data into MongoDB (Insert, Update or Upsert Mode) with various options. In this post we will more on how to create MongoDB Document for load process. We will see how to produce BSON (MongoDB Specific JSON which may have functions such as ObjectID, ISODate). This […] |
 |
How to Read / Write Amazon DynamoDB in SSISIntroduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.).ÃÂ We will discuss how to useÃÂ SSIS DynamoDB Source Connector […] |
 |
5 Ways to Export JSON from SQL Server using SSISIntroduction 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
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 […]
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 […]
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 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 […]
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 […]
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 […]
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 […]
