SSIS XML Destination (Create XML File)

SSIS XML Destination (Create XML File) 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

Generate complex XML from single or multiple inputs
Easy to use drag & drop layout Editor for creating complex XML with nested structure (Array, Attributes, Elements)
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: XML related articles

XML File Destination – Create XML File from input data source (Convert SQL to XML)

SSIS XML File Destination – Convert SQL to XML File

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

XML File Destination – Layout Editor (Define nested elements and Parent-Child relation)

SSIS XML File Destination – Add/Edit input Dataset

XML File Destination – Add/Edit input Dataset

SSIS XML File Destination – Layout Editor Right Click Menu

XML File Destination – Layout Editor Right Click Menu

SSIS XML File Destination – Add/Edit Attribute

XML File Destination – Add/Edit Attribute

SSIS XML File Destination – Add/Edit Document Array

XML File Destination – Add/Edit Document Array

Articles / Tutorials

Click here to see all articles for [SSIS XML File Destination] category

Calling SharePoint 365 REST API in SSIS

Introduction toÂ REST API with SharePoint in SSIS Using REST API with SharePoint in SSIS is a common requirement to Administer SharePoint. SharePoint 365 is a nice Microsoft application in the Cloud used to share documents and collaborate with the company. You can have schedules, projects, documents and more shared using a Web platform. In addition, […]

Articles/Posts

SQL Server JSON Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution4 Export SQL Server data to JSON using SSIS PowerPack5 Export SQL Server data to JSON using ZappyShell Command line6 SQL Server JSON Export – Single table7 SQL Server JSON Export – Multiple tables8 SQL Server JSON Export – Multiple tables (using pattern)9 SQL Server JSON Export – SQL Query10 Using […]

SQL Server Excel Export from Table or Query data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution3.1 Export Tables to CSV Using – ZappyShell Command Line Tools3.2 Export Tables to CSV Using – SSIS Export CSV File Task4 Download and Install ZappyShell Command Line Tools5 SQL Server Excel Export – Single table6 SQL Server Excel Export – Multiple tables7 SQL Server Excel Export – Multiple tables (using […]

Oracle CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install Oracle Drivers3.1 Sample Oracle ODBC Connection String3.2 Sample Oracle OLEDB Connection String4 Oracle CSV Export – Single table5 Oracle CSV Export – Multiple tables6 Oracle CSV Export – Multiple tables (using pattern)7 Oracle CSV Export – SQL Query8 Oracle CSV Export – Split […]

SQL Server CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install SQL Server Drivers3.1 Sample ADO.net Connection String (No driver needed)3.2 Sample ODBC Connection String (SQL Native Client Driver)3.3 Sample OLEDB Connection String (SQL Native Client Driver)4 SQL Server CSV Export – Single table5 SQL Server CSV Export – Multiple tables6 SQL Server CSV […]

MySQL Excel Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL Excel Export – Single table7 MySQL Excel Export – Multiple tables8 MySQL Excel Export – Multiple tables (using pattern)9 MySQL Excel Export – SQL Query10 MySQL Excel Export – Split Files and Tabs10.1 MySQL Excel Export […]

MySQL CSV Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 Download and Install MySQL ODBC Driver3 Download and Install ZappyShell Command Line Tools4 MySQL CSV Export – Single table5 MySQL CSV Export – Multiple tables6 MySQL CSV Export – Multiple tables (using pattern)7 MySQL CSV Export – SQL Query8 MySQL CSV Export – Split Files8.1 MySQL CSV Export – Split By Row Count8.2 […]

MySQL JSON Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL JSON Export – Single table7 MySQL JSON Export – Multiple tables8 MySQL JSON Export – Multiple tables (using pattern)9 MySQL JSON Export – SQL Query10 Using Map File for nested MySQL JSON Export11 MySQL JSON Export […]