This brings up the XML Task Editor
window, as shown in the following screenshot. It gets displayed with
OperationType, set to Diff as shown.
Creating a SSIS Package with an XML Task
[ 180 ]
2. Click on the DiffOptions node. This opens the various options that you can
choose, as shown in the next screenshot. The default options are all False,
meaning that none of these are ignored. For example, if for some reason you
need to compare two XML documents (ignoring the processing instructions
present in the XML documents to be compared), you may do so by setting
the first DiffOptions to true. Similarly, there are a number of possible
options that you can set.
Chapter 11
[ 181 ]
3. In the editor, change the SaveDiffGram from False to True. This will allow
saving the DiffGram document to a chosen location.
4. Click and expand the DiffGramSave node that gets displayed. This will
show two more items, DiffGramDestination and DiffGramDestination
Type that need to be specified as shown in the following screenshot. The
default for DiffGramDestination Type is File Connection.
5. In the DiffGramSave node of the previous screenshot, click on
DiffGramDestination. In the File Connection Manager Editor that
shows up:
Choose to create a file using the Usage Type: Create File from
the drop-down (the default is Existing file).
Provide the name CreatedXMLTsk1.xml (or any other if you
prefer) for the file.
Click on the Browse??¦ button to open the Select File
dialog, and find a suitable folder to which you may save the
CreatedXMLTsk1.
Pages:
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137