13. Click on the Browse??¦ button to open the Select File window dialog and
choose the second document discussed earlier, and click on the OK button.
This displays C:\Inetpub\wwwroot\webstudentsOK2.xml at File: in the
File Connection Manager Editor window.
14. Click on OK in the File Connection Manager Editor window. This adds
the file name to SecondOperand item of the Second Operand node. The
details of the SecondOperand node after these steps should appear as in the
following screenshot:
Three file connection managers will be added to the Connection Managers
page and the XML Task Editor appears as shown below. Note that the
Output node is not configured.
Creating a SSIS Package with an XML Task
[ 184 ]
15. Build the project and execute the package. After a few seconds, the XMLTask
component turns green on the Canvas. Look for the newly created file,
CreatedXmlTsk1.xml, in the root directory of your IIS where you saved it.
Open this file in the browser. The following XML file is displayed on the
browser, showing the differences between the two XML files.
Hands-On Exercise 2: XMLTask
Type XSLT
In this exercise we will transform the webstudentsOK.xml to an HTML
format displayed by a CreatedXmlTsk2.htm page using a transformation file,
webstudents.xsl described earlier.
The configuration follows the same steps as you need to access the File Connection
Manager Editor, each time you want to use an existing file, or create a new file on
your file system.
Pages:
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139