Included in SSIS PowerPack

SSIS XML Generator Transform

Build single or multiple XML documents from any data source inside the Data Flow, ready for files, SOAP calls or APIs.

XML Generator Transform builds single or multiple XML documents from any type of data source (e.g. SQL Server, MySQL, Flat File, Excel) inside the Data Flow. Join several inputs into parent/child nested XML with a drag-and-drop layout and live preview, add namespaces and prefixes, and pass the XML downstream, for example as a SOAP message for Web API Destination.

The trial includes XML Generator Transform and every other PowerPack component

XML Generator Transform in SSDT
Generate XML in the Data Flow and save it to a file or send it to another target.

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

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

At a glance

What XML Generator Transform can do

XML Generator Transform creates single or multiple XML documents from any type of data source (e.g. SQL Server, MySQL, Flat File, Excel) inside the Data Flow Task. The XML output can be stored to a file or sent to any target.

XML inside the Data Flow

Generate single or multiple XML documents from any data source inside the Data Flow Task.

  • Outputs an XML string column you can send to Web API Destination or save to a file

Create XML in SSIS guide

Nested XML from multiple datasets

Join different types of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relations for nested XML.

Component help

Layout editor with preview

Build simple or nested XML with a drag-and-drop layout and preview the structure as you change it.

  • Elements, attributes and document arrays

See the layout editor

One, many or batched documents

Create one XML document for all input records, one per parent record, or group rows into batches for bulk API requests.

  • OutputMode: one document for all records (batching allowed), one per parent record, or single dataset array
  • ArrayBatchSize sets rows per batch in single dataset array mode

Batch REST API requests

Namespaces & SOAP messages

Generate XML with namespaces and prefixes, for example a SOAP message for a web service.

  • Namespaces and RootElementPrefix
  • DoNotOutputXmlDeclaration and XmlStandAlone

XML namespace / prefix guide

NULL & empty-node handling

Leave out NULL attributes or elements and empty nested nodes.

  • DoNotOutputNullAttribute
  • DoNotOutputEmptyNestedAttribute

Component properties

Header, footer & formatting

Add document header and footer text and control indentation, formats and encoding.

  • DocumentHeader / DocumentFooter, or from an upstream column
  • IndentOutput, DateTimeFormat and Culture
  • Encoding or CharacterSet

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
  • Create simple or nested XML documents inside the Data Flow Task with drag and drop
  • Create nested XML from multiple datasets
  • Join different types of datasets (e.g. SQL Server, Flat File, Excel) for parent-child relations
  • Single XML document for all input records or one document per ROOT dataset row
  • Preview XML structure as you change the layout
  • Batch multiple rows into one XML document for API requests
  • Namespaces and prefixes (e.g. for SOAP messages)
  • Root element name, XML declaration and standalone options
  • Skip NULL attributes/elements and empty nested nodes
  • Document header and footer text
  • Indent output, date/time format, culture and encoding options
  • Logging modes up to Debugging, with optional timestamp prefix
  • 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, shape the XML in the layout editor, and pass the result downstream.

Generate XML in the Data Flow and pass it on.

Connect one or more sources (for example OLE DB Source, MongoDB Source or CSV File Source) to XML Generator Transform. It outputs XML in a column, which you can save to a file or send to another target such as Web API Destination.

  • Single or multiple inputs from any Data Flow source
  • One document for all records, per parent record, or single dataset array
  • Batch rows into one document for bulk API requests
XML Generator Transform generating XML and saving it to a file

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the XML Generator Transform product page. Step through them, or open any shot at full size.

Generate XML and save to file

XML Generator Transform outputs XML in a column that can be saved to a file or sent to any target.

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 XML Generator Transform on the canvas.

What is XML Generator Transform?

A Data Flow transform in SSIS PowerPack that builds single or multiple XML documents from any type of data source (e.g. SQL Server, MySQL, Flat File, Excel). The XML is output in a column that you can store to a file or send to any target, and a drag-and-drop layout editor with live preview handles nested parent/child XML.

Can it generate XML with namespaces, such as a SOAP message?

Yes. Set Namespaces and RootElementPrefix, then send the generated SOAP message to a web service with Web API Destination. See how to generate XML with namespace / prefix in SSIS.

Can I batch rows into one XML document per API request?

Yes. Group multiple input rows into one XML document per batch and POST each one with Web API Destination. See how to batch REST API requests in SSIS.

How is it different from XML File Destination?

The layout editor is almost identical. XML Generator Transform outputs XML in a column for further processing, while XML File Destination writes the XML straight to a file through a File Connection.

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 XML Generator Transform onto the Data Flow.

Shape nested XML from any Data Flow source and pass it to files, SOAP services or REST APIs.

  • Data Flow Transform in SSISXML Generator Transform 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