In this exercise, you will create the CreatedXmlTsk2.htm file in the
root directory of your IIS (saving it to IIS is not essential and it can be stored in any
directory of your choice). The completed XML Task Editor should appear as
shown here.
16. Right-click on XMLTask of Hands-on Exercise 1, and from the drop-down
menu, disable it. Add a new XMLTask from the Toolbox on to the Control
Flow page in the Canvas. You can disable a task which makes it inactive.
This was disabled in this exercise in lieu of creating another BI project
ating I all over.
Chapter 11
[ 185 ]
17. Edit the XML Task Editor so that it looks the same as the one shown in the
next screenshot. For the Destination line item in the node OperationResult,
you would choose to create a file (not use an existing one) and provide a
name and location.
18. Build the project and execute the XMLTask created for the OperationType,
XSLT. The project runs with this new XMLTask and afterwards turns green
indicating success.
Creating a SSIS Package with an XML Task
[ 186 ]
19. Now bring up the file C:\Inetpub\wwwroot\CreatedXmlTsk2.htm in your
browser (or from your chosen saved location). This is displayed as shown in
the following figure:
Summary
This chapter described in detail, the steps involved in using XMLTask that compares
two XML documents and writing the difference to another XML document. The
XML Task with the operation type XSLT that applies XSL transformation to an XML
file was also described.
Pages:
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140