Comparing the Script Task and the Script Component

Two design-time modes

In both the task and the component, you begin by specifying properties in the editor, and then switch to the development environment to write code.

Precompiled scripts

Beginning in SQL Server 2008 Integration Services (SSIS), all scripts are precompiled. In earlier versions, you could specify whether scripts were precompiled.

The script is precompiled into binary code, permitting faster execution, but at the cost of increased package size.

Control flow / Data flow

The Script task is configured on the Control Flow tab of the designer and runs outside the data flow of the package.

The Script component is configured on the Data Flow page of the designer and represents a source, transformation, or destination in the Data Flow task.

Execution

A Script task runs custom code at some point in the package workflow. Unless you put it in a loop container or an event handler, it only runs once.

A Script component also runs once, but typically it runs its main processing routine once for each row of data in the data flow.

Interaction with the package

In the code written for a Script task, you use the Dts property to access other features of the package. The Dts property is a member of the ScriptMain class.

In Script component code, you use typed accessor properties to access certain package features such as variables and connection managers.

The PreExecute method can access only read-only variables. The PostExecute method can access both read-only and read/write variables.

For more information about these methods, see Coding and Debugging the Script Component.

Using connections

The Script task uses the Connections property of the Dts object to access connection managers defined in the package. For example:

Dim myFlatFileConnection As String
myFlatFileConnection = _
    DirectCast(Dts.Connections("Test Flat File Connection").AcquireConnection(Dts.Transaction), _
    String) 

string myFlatFileConnection;
myFlatFileConnection = (Dts.Connections["Test Flat File Connection"].AcquireConnection(Dts.Transaction) as String);

The Script component uses typed accessor properties of the autogenerated base class, created from the list of connection managers entered by the user on the Connection Managers page of the editor. For example:

Dim connMgr As IDTSConnectionManager100
connMgr = Me.Connections.MyADONETConnection

IDTSConnectionManager100 connMgr;
connMgr = this.Connections.MyADONETConnection;

Logging

The Script task uses the Log method of the Dts object to log information to enabled log providers. For example:

Dim bt(0) As Byte
Dts.Log("Test Log Event", _
    0, _
    bt) 

byte[] bt = new byte[0];
Dts.Log("Test Log Event", 0, bt);

The Script component uses the Log method of the autogenerated base class to log information to enabled log providers. For example:

[Visual Basic]

Dim bt(0) As Byte

Me.Log("Test Log Event", _

0, _

bt)

byte[] bt = new byte[0];
this.Log("Test Log Event", 0, bt);

 Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

• Visit the Integration Services page on MSDN

For automatic notification of these updates, subscribe to the RSS feeds available on the page.