Objects can also be
created using the above syntax for Internet Explorer, SQL Data Management Objects,
Data Transformation Services, ADODB, FileSystemObject, etc. The ActiveX Script
Task creates these objects and works with them. Although, the examples shown in
this chapter all use VBScript (default), the other languages shown in the previous
screenshot can also be used.
Hands-On Exercise: Creating a Package
with ActiveX Script Tasks
In this chapter, we will be working with three examples. In the first example, you will
be using the ActiveX Script Task to access a word document to which you write a
short sentence (a sentence with some errors), and then you will be using the properties
and methods of the Word Object Model to count the number of spelling errors.
In the second example, you will be using an ActiveX Script Task to create a SQL Data
Management Object to determine the number of tables in the database of a named
server and the name of a table given its ordinal number.
In the third example, you will be connecting to Internet Explorer to bring up the web
page of the author's blog at: http://hodentek.blogspot.com.
All tasks will be created in the same package as individual tasks can be
executed independently.
Chapter 18
[ 265 ]
Example One: Word Automation
Step 1: Creating a BI Project and Adding an ActiveX
Script Task to the Package
1. Create a Business Intelligence Project Ch 18 and rename the default name of
the package.
Pages:
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186