Transforming, validating, and querying XML: XML Task

XML is a universal format for data on different platforms, and there are lots of companies that work with XML data and send and receive data through systems as XML files. There are some operations which can be done with XML data: validating XML files over XSD or DTD files, transforming XML data with XSLT, querying data from XML with XPath, and other operations that are supported in many applications and programming languages nowadays.

The SSIS XML Task is a powerful task that provides a few of these operations on XML data. In this recipe, we fetch data from a table as XML, validate it on an XSD file, and then transform it with XSLT.

Getting ready

1. Save the contents of books.xml and books.xsd from this address into physical files: http://msdn.microsoft.com/en-us/library/ms762258(v=VS.85).aspx.

2. Create a new empty file at this address: C:\SSIS\Ch02_Control Flow Tasks\R07_XML Task\Files\xslt_result.xml.

How to do it...

1. Create a new SSIS project and...