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 4th 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