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 physical files: http://msdn.microsoft.com/en-us/library/ms762258(v=VS.85).aspx.
How to do it...
Create a new Integration Services project in BIDS, and name the project as
R04_XMLSource.Add a Data Flow Task in the Control Flow, and double-click on...
