Prev | Current Page 124 | Next

Jayaram Krishnaswamy

"Beginners Guide to SQL Server Integration Services Using Visual Studio 2005"

xml under Diff XMLTask type.
This is a well-formed XML document with as root, containing four student
nodes with ID as their attribute.
The XSL Document to transform the above XML is given as follows:
Listing of the webstudents.xsl

version="1.0">













studied






Chapter 11
[ 179 ]
Hands-On Exercise 1: XMLTask type Diff
In this exercise we will use the two documents, webstudentsOK.xml and
webstudentsOK2.xml, and generate a DiffGram document that shows the difference
between the two documents.
Step 1: Create a BI Project and Add a Control
Flow task, XMLTask
This process has been described a number of times in the previous chapters.
Create a BI project, Ch11. Change the name of the default package name to XMLDiff.
dtsx. Drag and drop an XMLTask from the Control Flow Items group in the
Toolbox to the Control Flow page on the Canvas. An instance of XMLTask will be
added to the Canvas on the Control Flow page.
Step 2: Configuring XMLTask
1. Right-click on the XMLTask component on the Canvas, and from the
drop-down menu, choose Edit??¦.


Pages:
112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136
Mezo Moloko Veronica Mortensen Limp Bizkit M-People