Pages

Saturday 9 March 2013

Difference Between Script Task and Script Component

Script Task VS Script Component :

While both the objects provide scripting environments using the VSTA engine, yet there are inherent differences in their purpose and functions. This is due to their design architecture and the placement in development environment.

Ø  The main difference of Script Task and Script Component is the way the script is executed by both the objects. The Script Task executes the script only once for each execution instance of the task, while the Script Component generally executes the script for each row, as it applies the custom transformation on each of the data row reads.

Ø  The Script Task is available in the Control Flow task tab, while the Script Component works in the pipeline or the Data Flow Task.

Ø  You can choose Script Component as a Source, a transformation, or a destination. The choice of function and the metadata and properties you configure in the editor results in creation of different members of the base classes in the auto-generated code. The Script Task does not provide any such facility, as the code generated is always the same.

Ø  The Dts property works with only the Script Task and it is not available in the Script Component.

Ø  The Script Task supports breakpoints while Script Component does not support breakpoints. 

5 comments:

  1. Hi,
    The above article given a value points about Difference Between Script Task and Script Component. Differences between the Script Task and the Script Component. ... 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. Purpose. A Script task can accomplish almost any general-purpose task.

    ReplyDelete
  2. Very nice blog! I enjoy reading through your article post, I wanted to write a little comment to support you and wish you a good continuation. All the best for all your blogging efforts....
    The Script Component provides another area where programming logic can be applied in an SSIS package. Each Script Task is called only once within a Control Flow, unless it is in a looping control. The Script Component has to be higher octane because it is going to be called per row of data in the data stream. Here we have some stuff regarding script component and script task. This information is helpful to you.
    Using the script component in SSIS

    ReplyDelete
  3. I think your blog is great information source & I like your way of writing and explaining the topics. Keep it up. if You Want More Details about MSBI Interview Question click here.

    ReplyDelete
  4. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training

    ReplyDelete
  5. Thank you for sharing, I would like to add that the script task can validate important columns in the source data and skip records that contain invalid data to prevent them from being copied to the destination. For example, a script can assess the reasonableness of a postage amount and skip records with extremely high or low amounts.

    ReplyDelete