{"id":1115,"date":"2017-04-26T14:14:11","date_gmt":"2017-04-26T14:14:11","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=1115"},"modified":"2018-05-23T16:41:59","modified_gmt":"2018-05-23T16:41:59","slug":"tutorial-create-xml-in-ssis-export-xml-file-output","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/tutorial-create-xml-in-ssis-export-xml-file-output\/","title":{"rendered":"How to export XML from SQL Server using SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

In our previous blog post we saw how to import xml into SQL server using SSIS<\/a>. In this post we will see how to\u00a0generate xml in SSIS.\u00a0If you wish to export JSON rather than XML then check this article<\/a><\/p>\n

To produce complex nested XML\u00a0you can use following two task\/components.<\/p>\n

\n\n\n\n\n
\"Custom<\/td>\nExport\u00a0XML File Task<\/a><\/td>\n<\/tr>\n
\"SSIS<\/td>\nXML Generator Transform<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Video Tutorial – Create XML in SSIS<\/h2>\n

Below video tutorial will show you how to produce complex XML from single or multiple input datasets using SSIS.<\/p>\n

Techniques illustrated in below video is almost identical for SSIS Export XML File Task and SSIS XML Generator Transform… but for demonstration we will use XML Generator Transform. If you wish to use Export XML File task then dataset will be Table or Query rather than Data flow Input.
\n

<\/div><\/div>
<\/div>
<\/div>
<\/div><\/div><\/div>