Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 19 – ActiveX Script task container

 

This is part 19 of the series of article on SSIS. It describes using ActiveX Script task container in SSIS package.

Introduction

In this article 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. Let’s see a simple example of how to use this task and execute a script.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

Steps:

Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use ActiveX Script task container and execute a script.

Drag and drop the ActiveX script task container as shown in the below screen.

clip_image001

Now in order to execute a script at the start of the SSIS Package we need to provide the startup script to the script container. To provide the script right click on the ActiveX script task and select Edit. It will show a window as shown in the below screen.

clip_image002

Move on to the SCRIPT tab, which is the main section we need to concentrate since we are going to write the script in this section.  Here we have 2 sections one is

LANGUAGE – this section we need to provide which scripting language we going to write the script.

SCRIPT– this section we are going to right the click, just click on the button at the right side will open a window to write the script as shown in the below screen.clip_image003

Here I have written a bit of code to write a string to a file as shown in the below screen.

clip_image004

ENTRY POINT – You need to provide which is the entry point for the script, in our case you need to give it as MAIN().

Once we wrote the script now click on OK will move back to the previous screen. In that screen at the bottom you can see an option like PARSE. Clicking on that button will check the syntax and give the result as shown below.

clip_image005Once all the configurations are over, now we need to execute the package and see if the script has been execute perfectly. To do that right click on the ActiveX Script task and give execute task as shown in the below screen.

clip_image006

It will show the result as shown in the below screen.

clip_image007

And the result, a file will be created at the location specified as shown in the below screen.

clip_image008

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter