SQLServerCentral.com Content tagged XML, XSLT

Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS

Wed, 28 Mar 2012 06:00:00 UT

This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.

Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS

Wed, 21 Mar 2012 06:00:00 UT

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.

Basics of XML and SQL Server, Part 1: Streaming XML

Wed, 07 Mar 2012 07:00:00 UT

This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.