Thursday, May 22, 2008

SSIS: ActiveX Script Task

Activex Script Task allows to write our own custom code by using activex Script languages. at present, this task supports following 4 scripting languages
  1. VB Script Language
  2. JScript Language
  3. SignedJavaScript Class
  4. SignedVBScript Class
ActiveX script has typically been used for the following purposes:
  • Including business logic in packages. For example, ActiveX script can use conditional logic to manage package workflow.
  • Writing functions that use conditional logic to set variable values. For example, an ActiveX script can access values in a database table by using ActiveX Data Objects (ADO) and populate variables with the table values.
  • Performing complex computations. For example, an ActiveX script can compute new dates by applying built-in functions such DateAdd and DateDiff to data values.
  • Accessing data using other technologies that are not supported by built-in connection types. For example, an ActiveX script can use Active Directory Service Interfaces (ADSI) to access and extract the user names from Active Directory.
If you have existing ActiveX scripts that you would like to continue to use until they can be upgraded, you can configure the ActiveX Script task in the following ways:
  • Provide the existing script that the task runs.
  • Specify the scripting language that was used in the script. The ActiveX Script task supports the VBScript and JScript languages and other scripting languages installed on the local computer.
  • Specify the name of the function that is the entry point for the script.

No comments:

Post a Comment