Database Reference
In-Depth Information
Figure 9-7
.
XML task configuration
Note
The XML task was updated in the SQL Server 2012 release to use the latest
.NET XML technologies. The performance of applying XSLT scripts is much better
than in previous versions.
Listing 9-5
shows us what our sample XML document looks like after applying the
XSLT script from
Listing 9-4
.
We can see that all of the fields we need to extract are
now under a single
parent
element. The schema for this new XML format gives us a
Search WWH ::
Custom Search