SSIS JSON File Destination
Write simple or nested JSON files from one or many Data Flow inputs, such as SQL Server, MySQL, flat files or Excel.
JSON File Destination writes simple or nested JSON files from single or multiple Data Flow inputs (e.g. SQL Server, MySQL, Flat File, Excel). Design the shape in a drag-and-drop layout editor with document arrays, value arrays and parent/child relations, then write it to a file as one document, multi-content JSON or one file per parent row.
The trial includes JSON File Destination and every other PowerPack component
- Data Flow Destination in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial

At a glance
What JSON File Destination can do
JSON File Destination generates simple or complex JSON files from single or multiple Data Flow inputs. In a few clicks you can shape JSON from one or many tables, including parent/child nested documents.
Nested JSON from multiple inputs
Generate simple or complex JSON files from single or multiple Data Flow inputs (e.g. SQL Server, MySQL, Flat File, Excel).
- Parent/child nested documents from multiple tables
- Any Data Flow source can be attached, not only OLE DB or ODBC
Drag & drop layout editor
Design the JSON shape in an easy drag-and-drop layout editor.
- Document Array, Value Array and attributes
- Add or edit input datasets and parent-child relations
- SSIS variables inside the layout for dynamic JSON
Output modes
Choose one JSON for all input rows or one JSON per parent row with OutputMode.
- Single JSON in multi-content or array format (batching allowed)
- One JSON per parent input row, or a single dataset array
ArrayBatchSizesets rows per batch for single dataset array mode
Compact 2D arrays
Output a Document Array or Value Array as a compact 2D array.
- Output as Compact 2D Array checkbox in Add/Edit Element
- Array2D, Array2DWithHeader, ArrayLines and ArrayLinesWithHeader formats
NULL & empty-node handling
Leave out NULL attributes, empty nested nodes and empty arrays from the output.
DoNotOutputNullAttributeDoNotOutputEmptyNestedAttributeDoNotOutputEmptyArrayAttribute
Header, footer & formatting
Add document header and footer text and control indentation, date/time and number formats.
DocumentHeader/DocumentFooter, or from an upstream column (UseColumnForHeaderFooter)IndentOutputfor pretty printDateTimeFormatandCulture
File write & encoding
Write to a File Connection with overwrite or append and the encoding you need.
OverwriteIfExistsandAppendEncoding: UTF-8, UTF-16, UTF-32 and more, with or without BOM
SQL Server 2012–2025 & ADF
Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
- Azure Data Factory (SSIS IR)
- Design packages in Visual Studio 2017, 2019, 2022, or 2026
- Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025
See all features
- Generate simple or complex JSON files from single or multiple Data Flow inputs
- Easy drag & drop layout editor for nested JSON (Document Array, Value Array)
- Parent/child nested documents from multiple tables
- Works with any upstream Data Flow source (e.g. SQL Server, MySQL, Flat File, Excel)
- Output modes: single JSON (multi-content or array), one JSON per parent row, single dataset array
- Compact 2D array output (Array2D, ArrayLines, with or without header)
- Skip NULL attributes, empty nested nodes and empty arrays
- Document header and footer text, from a direct string or an upstream column
- Indent output (pretty print), date/time format and culture settings
- Overwrite or append to the target file
- Encoding options with or without BOM
- Logging modes up to Debugging, with optional timestamp prefix
- SSIS variables in the layout for dynamic JSON
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
How it works
From the toolbox to your first run.
Connect inputs, pick the file and output mode, then shape the JSON in the layout editor.
Connect one or many Data Flow inputs.
Drop JSON File Destination on the Data Flow and connect one or more upstream components, for example customers and orders, so they can be joined into nested JSON. Any Data Flow source works: SQL Server, MySQL, flat files, Excel and more.
- Single or multiple inputs
- Parent/child nested documents across inputs
- Not limited to OLE DB or ODBC sources

Pick the file connection and output mode.
Select the File Connection for the target file and check Overwrite target file. Set Output Mode, for example Output Single JSON – Multi Content Format, and check Indent Output for pretty print.
- Single JSON as multi-content or array, one JSON per parent row, or single dataset array
OverwriteIfExistsorAppend- Encoding with or without BOM

Shape nested JSON with the layout editor.
Right-click Mappings and choose Add Element(s), then pick Add Multiple (Bound) and the columns to output. Add document arrays and value arrays for child rows, and edit any dataset from the same screen.
- Elements, attributes, document arrays and value arrays
- Parent/child relations between datasets
- Skip NULL attributes, empty nested nodes and empty arrays

Output an array as a compact 2D array.
Add a Document Array or Value Array, then check Output as Compact 2D Array in the Add/Edit Element dialog. For rows with columns id and name, Array2D gives [[1,"AA"],[2,"BB"]].
- Array2D and Array2DWithHeader
- ArrayLines and ArrayLinesWithHeader
- Default array of documents or multi-content output

Inside the UI
Key settings, as they appear in SSDT.
Real screens from the JSON File Destination product page. Step through them, or open any shot at full size.
Create JSON File from multiple input source
Connect several upstream inputs to one JSON File Destination and join them into nested JSON.
Articles
Worked examples that use JSON File Destination.
Compatibility and requirements
Designed to stay inside your SSIS runtime.
- SQL Server 2012 through 2025, 32-bit and 64-bit
- Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
- Azure Data Factory SSIS Integration Runtime
- Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
- Fully functional 30-day trial of SSIS PowerPack
FAQ
Questions teams ask before they drop JSON File Destination on the canvas.
What is JSON File Destination?
A Data Flow destination in SSIS PowerPack that writes simple or nested JSON files from single or multiple inputs (e.g. SQL Server, MySQL, Flat File, Excel). A drag-and-drop layout editor defines document arrays, value arrays and parent/child relations, and the output goes to a File Connection.
How is it different from JSON Generator Transform?
The layout editor and concepts are almost identical. JSON Generator Transform outputs JSON in a column for downstream components, while JSON File Destination writes the JSON to a file through a File Connection.
Which output modes are available?
OutputMode offers Output Single JSON in multi-content or array format, Output One JSON per Parent Input Row, and Single Dataset Array, where ArrayBatchSize sets how many rows go in each batch (0 = all in one).
Can it split output into multiple files?
No. File splitting is not available in JSON File Destination. If your data comes from OLE DB, ADO.NET or SQL Server connections and you need split files, GZip or direct cloud export, use Export JSON File Task; see the 5 ways to export JSON comparison.
Which SQL Server versions can I run it on?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.
Start your free trial today
Install SSIS PowerPack and drag JSON File Destination onto the Data Flow.
Shape nested JSON from any Data Flow source in a visual editor and write it straight to a file.
- Data Flow Destination in SSISJSON File Destination appears in the toolbox after you install PowerPack.
- Fully functional 30-day trialSSIS PowerPack, running in your environment.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.