Package with an ActiveX
Script Task
ActiveX was one of the main programming backbones of DTS, the tool that was
replaced by SSIS in SQL 2005. The ActiveX Script Task in SSIS is provided for
backward compatibility, especially useful for migrating DTS packages that have
custom code using a scripting language. Support for ActiveX in SSIS is very limited,
and Microsoft recommends using the faster and more stable Script Task using
the .NET framework classes. The ActiveX Script Task will be discontinued in the
future versions.
The ActiveX Script Task can be created through code and every detail needed for
scripting is provided by the Microsoft.SQLServer.DTS.Tasks.ActiveX Script Task
namespace. There is no intellisense support, but the task can cater to several scripting
languages as shown below.
CreateObject () method is a much used native method for creating objects
(Automation Objects). The syntax used for creating an object is:.
CreateObject (servername.typename [, location])
Package with an ActiveX Script Task
[ 264 ]
Most of the Microsoft Office applications' automation objects are created using
this method. For example, the following VBScript statements create objects in
various applications:
Set WordApp=CreateObject ("Word.Application","Hodentek") would create
a MS Word application on the computer "Hodentek"
Set xlObj=CreateObject ("Excel.Application") would create an
MS Excel application.
Once the Application Object is created, then one has to know the Application's
Programming Interface (API) to access methods and properties.
Pages:
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185