SSIS Export XML File TaskSSIS Export XML File Task

SSIS Export XML File Task can be used to generate simple or complex XML files out of relational data source such as SQL Server, Oracle, MySQL. In few clicks you can create desired XML Shape from single or multiple tables (Parent/Child Nested Documents)

Features

  • Export multiple tables/views to XML files (e.g. Sales% or do SalesJan|SalesFeb)
  • Export SQL query output to XML file
  • Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Value Array, Nested attributes
  • Automatically Split exported XML data into multiple files by Size or Number of records
  • Automatically Split exported XML data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
  • Support for Compression and Append
  • Create Multi content XML 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: XML related articles
See also
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API)
Custom SSIS Tasks - Export JSON File Task Export JSON File Task
Custom SSIS Tasks - JSON Parser Task XML Parser Transform
Custom SSIS Tasks - Call REST API Webservice (GET, POST, DELETE etc) XML Generator Transform
Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements

In visual studio just Drag and Drop ZS Export XML Task in the design surface

Drag and Drop ZS Export XML Task in the design surface

Drag and Drop ZS Export XML Task in the design surface

SSIS Export XML File Task – Select Source Tables, Queries, Connection

SSIS Export XML File Task - Select Source Tables, Queries, Connection. You can use simple mode to export to XML from selected tables / query or use custom layout mode for creating complex XML.

SSIS Export XML File Task – Select Source Tables, Queries, Connection. You can use simple mode to export to XML from selected tables / query or use custom layout mode for creating complex XML.

SSIS Export XML File Task – Select Target Mode, Path and Options

SSIS Export XML File Task - Select Target Mode, Path and Options. You can save exported XML to local file or save to SSIS Variable. You can also compress the exported file in GZip format.

SSIS Export XML File Task – Select Target Mode, Path and Options. You can save exported XML to local file or save to SSIS Variable. You can also compress exported file in GZip format.

SSIS Export XML File Task – Select XML Format Options

SSIS Export XML Task Options - Here you can define namespace / XML prefix. You can also control many aspects of XML Generation (e.g. Root Node, Declaration, NULL Handling, Encoding, Datetime format and many more).

SSIS Export XML Task Options – Here you can define namespace / xml prefix. You can also control many aspects of XML Generation (e.g. Root Node, Declaration, NULL Handling, Encoding, Datetime format and many more).

SSIS Export XML File Task – Split file options (Split by Size, Row count and Group by column

SSIS Export XML File Task - On this screen you can control file splitting options. If you have many records and you don't wish to dump into one big file then use this screen. You can split export records into smaller files. Split by Size, Split By Row Count, You can also Split by Column Value (Group By Column)

SSIS Export XML File Task – On this screen you can control file splitting options. If you have many records and you don’t wish to dump into one big file then use this screen. You can split export records into smaller files. Split by Size, Split By Row Count, You can also Split by Column Value (Group By Column)

SSIS Export XML File Task – Layout Editor (Define nested elements and Parent-Child relation)

SSIS Export XML File Task - Using visual layout editor it makes it super easy to craft complex XML using drag and drop approach. You can define nested elements and Parent-Child relation. You can use the live preview feature to see XML structure.

SSIS Export XML File Task – Using visual layout editor it makes it super easy to craft complex XML using drag and drop approach. You can define nested elements and Parent-Child relation. You can use live preview feature to see XML structure.

SSIS Export XML File Task – Add/Edit input Dataset

SSIS Export XML File Task - Add/Edit input Dataset (Read from Table or SQL Query)

SSIS Export XML File Task – Add/Edit input Dataset (Read from Table or SQL Query)

SSIS Export XML File Task – Layout Editor Right Click Menu

SSIS Export XML File Task - Layout Editor Right Click Menu

SSIS Export XML File Task – Layout Editor Right Click Menu

SSIS Export XML File Task – Add/Edit Attribute

SSIS ExportXML File Task - Add/Edit Attribute

SSIS Export XML File Task – Add/Edit Attribute

SSIS Export XML File Task – Add/Edit Document Array

SSIS Export XML File Task - Exporting SQL data to nested XML file (Add/Edit Document Array)

SSIS Export XML File Task – Exporting SQL data to nested XML file (Add/Edit Document Array)

SSIS Export XML File Task – Execution Log

Exporting SQL data to multiple XML files using SSIS Export XML File Task

Exporting SQL data to multiple XML files using SSIS Export XML File Task

Articles / Tutorials


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

Posted: June 10, 2015

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 Logo

SQL Server Excel Export from Table or Query data

Posted: June 10, 2015

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

0 comments
Oracle Logo

Oracle CSV Export from Table or Query Data

Posted: June 10, 2015

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

0 comments
SQl Server Logo

SQL Server CSV Export from Table or Query Data

Posted: June 10, 2015

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

0 comments

MySQL Excel Export from Table or Query result

Posted: June 5, 2015

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

1 comment

MySQL CSV Export from Table or Query result

Posted: June 5, 2015

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

0 comments

MySQL JSON Export from Table or Query result

Posted: June 5, 2015

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

0 comments

References

Click here to learn more about System Requirements
Download View All Tasks Like This

Keywords

    How to export data to XML file in SSIS
    Generate XML file in SSIS
    Produce XML file in SSIS
    Create XML file in SSIS
    Create nested XML file in SSIS