Included in SSIS PowerPack

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

JSON File Destination in SSDT
SSIS- JSON File Destination - Create JSON File from multiple input source
Join several Data Flow inputs into one JSON File Destination to build nested JSON.Explore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

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

5 ways to export JSON

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

See the layout editor

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
  • ArrayBatchSize sets rows per batch for single dataset array mode

Component properties

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

Component help

NULL & empty-node handling

Leave out NULL attributes, empty nested nodes and empty arrays from the output.

  • DoNotOutputNullAttribute
  • DoNotOutputEmptyNestedAttribute
  • DoNotOutputEmptyArrayAttribute

Component properties

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)
  • IndentOutput for pretty print
  • DateTimeFormat and Culture

Component properties

File write & encoding

Write to a File Connection with overwrite or append and the encoding you need.

  • OverwriteIfExists and Append
  • Encoding: UTF-8, UTF-16, UTF-32 and more, with or without BOM

Component properties

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

Compatibility and requirements

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

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

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
JSON File Destination joining multiple Data Flow inputs

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.

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.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

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.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 9