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

Importing XML data with XML Source

XML is a global and platform-independent method to transfer data as we mentioned earlier. In the previous chapter, we used Web Service Task to fetch results of a web method into an XML file; also we tried to change the style of the XML data with XML Task. One of the most useful scenarios with XML data is to import the data into a database. We can do this with the help of XML Source.

XML Source provides a way to read data from the xml file based on the XSD schema file. XML Source can read simple flattened xml data or more complex data with hierarchical structure. In this recipe, we will import books.xml data into SQL Server database table.

Getting ready

Save contents of books.xml and books.xsd from this address into ...

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