l file.
Now click on the OK button in the File Connection Manager
Editor.
The details of DiffGramSave node will be as shown in the
following screenshot:
?° ?° ?°
?°
Creating a SSIS Package with an XML Task
[ 182 ]
6. Click on the Input node to display the line items where you can indicate
SourceType, as well as Source. SourceType has three options: Direct Input,
File Connection and Variable. We will use File Connection option, which
also happens to be the default option.
7. Accept the default source type, and click on an empty area of the Source line
item, and from the drop-down, click on the item New File Connection??¦.
This opens the File Connection Manager Editor as shown. In this exercise,
you will be using an Existing file.
8. Use the Browse??¦ button to locate the webstudentsOK.xml file on your
C:\ drive.
9. Click on the OK button after making this choice. The webstudentsOK.xml
file then appears in the File Connection Manager Editor window, as shown
in the following screenshot:
10. Click and expand the Second Operand node to reveal SecondOperandType,
and SecondOperand items.
Chapter 11
[ 183 ]
11. Click by the side of Direct input for the item, SecondOperandType. This will
display a list. From there, choose File Connection.
12. Click in an empty area in the SecondOperand item and choose New File
connection.... This opens the File Connection Manager Editor. The editor
comes up with default usage type??”Existing file.
Pages:
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138