O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required