The default name was changed to ActiveXDemo.dtsx in this exercise.
2. Drag and drop an ActiveX Script Task from the Control Flow Items group
from the Toolbox onto the Control Flow Page of the Canvas.
3. Right-click the ActiveX Script Task and from drop-down choose Edit??¦
(or double-click the ActiveX Script Task component).
This opens up the ActiveX Script Task Editor, as shown in the next screenshot.
This window is same for all the tasks we will be creating. You can provide
a Name and a Description for this task.
In this example, the Name and Description are as follows, respectively,
"Count Spelling Errors" and "Count Number of errors in a Microsoft Word
Document".
4. Make the above changes to Name and Description line items and click on the
Script list item on the left.
Package with an ActiveX Script Task
[ 266 ]
This opens the ActiveX Script Task Editor's Script related page, as shown in
the following screenshot with the default, VBScript Language.
5. Click near the point marked 1 along the line item Script, as shown in the
previousscreenshot.
This opens a text editor window, ActiveX Script, which is initially empty. The
developer is supposed to type in the code.
It is also possible to look for a saved script file (*.txt) on the machine using
the Browse??¦ button. This window also allows you to parse the script or save
the script using appropriate buttons.
In the present example, we will be using the following script to create an
instance of Microsoft Word Automation object, and then present it with a
sentence with errors, and programmatically find the number of spelling errors
present in the sentence.
Pages:
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187