MSBI # 26 – SSIS # 13 – Control Flow Tasks # 8 – ActiveX Script Task

Hi all ,

First a fall if you are rally interested in Active-X script task then  only read this article ,Because it has not been use now a days !!

Its has been used in 2000 its decade now still I feel like having post on same.

All we use is script task !! But still as I have promised my reader to have an n to end knowledge about BI world I must explained it !!

So today we are going to cover each and every aspect of ActiveX Script Task

We are covering following points in this article

• Why ActiveX Script Task is Use ?
• How ActiveX Script Task is look like ?
• Comparing the ActiveX Script Task and the Script Task !!
• Features of ActiveX Script Task
• How to use ActiveX Script Task ?
• What is alternative For Each ActiveX Script Task ?
• Demonstration of using ActiveX Script Task ?
• Various Properties For each ActiveX Script Task ?
• Reference link For ActiveX Script Task

Why ActiveX Script Task is Use ?

On the very First page of MS you are going to see at the top only following note with mark

The ActiveX Script task provides a way to continue to use custom code that was developed using ActiveX script, until such scripts can be upgraded to use the more advanced features provided by the Script task.

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.

  How ActiveX Script Task is look like ?

It just a 4^th task in Tool Box !!

Lets drag that out in our Development plane !

Features of ActiveX Script Task

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.

  Comparing the ActiveX Script Task and the Script Task

When you write new scripts for SQL Server Integration Services packages, you should always consider using the Script task instead of the ActiveX Script task. The Script task offers the following advantages:

• Scripts written in programming languages such as Microsoft Visual Basic .NET can be precompiled to deliver better performance.
• Scripts coded in the VSA environment are supported by integrated Help, IntelliSense, and debugging.
• Scripts can reference external .NET assemblies in addition to the standard .NET framework and COM objects.

  How to use ActiveX Script Task ? and

Demonstration of using ActiveX Script Task ?

Lets move head with my same solution add one more package in in for demonstration

 

• In this demonstration we are going to see on how to use ActiveX Script task container in SSIS packaging.
• Here we take some simple example of executing a VB Script at runtime using the ActiveX Script task container.
• This task container is mostly used on when we move the SQL 2000 DTS objects to SSIS packaging.
• So this task container is used to customize our process of writing script and executing those scripts at runtime.

On the pragmaticworks I just found for following all purpose we are using Active X Script task

Lets Drag this task

Now configured it with your any of the following required option

In this Script task we have language selection option

Not only that I would like to specially highlight you option like Browse,Save and Parse

Which means if you have script ready with you in TXT format just brose it or parse it

But again we can write our own script too !! Just By clicking following option

We get nice Scripting plane for Script writing

So just write any VB code inside it and execute it as you want.

What is alternative For Each ActiveX Script Task ?

This is most important question as it difficult and we mostly use C# we will always use Script task in place of this task

So Alternative for ActiveX Script Task is just Script Task

Various Properties For each ActiveX Script Task ?

Properties for ActiveX Script Task are as shown in property plane

Some of explanation for properties

Reference link For ActiveX Script Task

• script task and active x script task | SQL Server Performance ForumsActiveX Script Task
• ActiveX Script Task :MSDN
• ActiveX Script Task:MSDN
• FAQ – How to convert ActiveX Script to native SSIS
• ActiveXScriptTask Class (Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask):MSDN

Thanks for visiting my blog !!

Hope you have understood various aspect of ActiveX Script Task and ready to use 

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Link Resource # 20 : Aug 26 – Aug 28 « Dactylonomy of Web Resource