Video is ready, Click Here to View ×


In this video tutorial you will learn following things

* How to produce nested XML from multiple data sources inside SSIS Data Flow
* How to produce nested XML from single data sources inside Data Flow
* Save generated XML into local file
* Techniques shown in this video can be applied to the following task/component
– SSIS XML Generator Transform
– SSIS Export XML File Task

==============================
SSIS XML Generator Transform
==============================
SSIS XML Generator Transform can be used to generate single or multiple XML documents from any type of datasources (e.g. SQL Server, MySQL, Flat File, Excel) inside dataflow task.

Features
=======
◾Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach
◾Ability to create nested XML from Multiple datasets
◾Ability to create single XML document for all input records or create one document for each input row from ROOT dataset
◾Preview XML structure as you change layout on User Interface
◾Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

http://zappysys.com/products/ssis-powerpack/ssis-xml-generator-transform/

==============================
SSIS Export XML File Task
==============================
SSIS 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
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

http://zappysys.com/products/ssis-powerpack/ssis-export-xml-file-task/